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 Rhinorhino 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

puforee

Technical User
Joined
Oct 6, 2006
Messages
741
Location
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.
 
Sort by date Sort by votes
Cancel...I found fix going throug Google. Auto number seed needed to be reset.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Field size limit Access 365
Replies
5
Views
6K
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question Question
Using old IDs as Autonumbers
Replies
6
Views
1K
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question Question
Field to count specific records
Replies
3
Views
926
dhookom
dhookom
JayRo71
  • Locked
  • Question Question
Importing only unique records from excel tables
Replies
10
Views
1K
SkipVought
S
TrekBiker
  • Locked
  • Question Question
Prevent new data being used when using Archive backend
Replies
0
Views
5K
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top