Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with MS Access Primary Key - They Reset

Status
Not open for further replies.

johnsun1976

Programmer
Joined
Jan 28, 2002
Messages
34
Location
CA
Hi, I have this weird problem with a primary key in a table.. It happen twice already.. For some reason, the primary was reset to a lower number than highest key.. For example, the highest key is 2222, and some how, the key got reset and is trying to insert 2210 and would not allow the user to insert another record. I can't figure out why this would happen.. The database is being used by two users. Can someone shed some light on this?
Thanks
John
 
ReInstall Access that is not normal. So it might be an internal problem with access
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top