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!

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

Problem with Auto Numbering

Status
Not open for further replies.
dawnd3

dawnd3

Instructor
Jul 1, 2001
1,153
US
Hi All, I was trying to append some records to a table and got the Key Violations error message. Upon investigating, I discovered that a new record added to the table creates a duplicate number in the autonumber field (which is set as the primary key, not to allow duplicates.) I have never seen this happen before. Any ideas on how I fix it. I use Access 2010.
Thanks,

Dawn

 
Sort by date Sort by votes
Nevermind, fixed with a compact and repair. :)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
460
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
415
Andrzejek
Andrzejek
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
3K
Anthony343242
Anthony343242
jjMedrano
  • Locked
  • Question
UNION ALL with Attachment data type 1
Replies
8
Views
304
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top