Primary Key Field

A

amber

Are there any issues with having a primary key value of 0
for a particular record?

It seems like the record I have with a 0 as the primary
key field has disappeared. All of my users deny having
deleted or altered the record to which I refer. Is this
bad structure to use a 0?


Thanks,
Amber
 
S

Scott M.

There shouldn't be unless you have some criteria set in Access that prevents
that number from being a valid number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Index/Primary Key Error Handler 1
No Primary Key! 4
Primary Keys yes or no? 8
How can I Manually Change Access Primary Key ID Fields ? 2
Duplicate values in the index, primary key, or relationship messag 2
Split form 0

Top