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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Emergency...Autonumber field repeating when ne record is added...Error messages

Status
Not open for further replies.

puforee

Technical User
Oct 6, 2006
741
0
0
US
I have a DB that has been working form months. One Major Table has been accepting records over this time frame.

All of a sudden the table is repeating Autonumbers or course causing errors indicating an indexed or Key value has been duplicated. Duplicates for this field is set to NO.

I have done a repare DB - to no avail.

Help...I have users that need to add records.
 
Cancel...I found fix going throug Google. Auto number seed needed to be reset.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top