My Autonumber Has reset to 1 ?

[BillHesson]

I have an inventory split database. It has been working fine. I noticed when I try to enter a new record, it will not let me as it would create a duplicate record. It has actually started to use the autonumbers in the pk again reusing numbers that already exist starting at 1 and moving up sequentially.

How can I make it continue from where it left off or at least not duplicate any of the existing records. This database has many tables with a bunch of relationships.
Thanks!
Bill Hesson

 

[BillHesson]

I saved a copy of the table and recreated the relationships renamed original table to old and renamed new table to the original name all is working fine.
Still Baffeleing how this happend or how else to fix.

 

[Pat Hartman]

This is a known bug in Access. You can try obtaining the latest release of Jet. That is supposed to fix the problem although it didn't for me. I had to do a similar thing. I did track down that a particular form was actually causing the problem. I ended up having to rebuild the form as well as rebuilding the table.

 

[BillHesson]

Thanks Pat!