autonumber is entering duplicate numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables one for customer and one for contracts. The auto
numbering on the contract table has started inputting previously used numbers
for records and will not let me save - error message reads "duplicate record"
- I do not know why this has started happening. ????
 
Try a compact and repair. You may well have a corruption problem.

Also there was a bug in Access 2003 (I believe) that was fixed by a service
pack. Make sure that you have all the most current service packs installed.
 
Back
Top