Autonumber isn't incrementing anymore!

[racemadnss]

I created a database for my parents last summer and it has worked perfectly for a year now, then all of a sudden when they try to add an entry to the database its saying that it can't because it will create a new field.

Turns out my parents have added 45000 entries and it has just randomly reset the autonumber and is trying to add new entries at 25000, now my parents company is in a gridlock till I can figure out what the heck access did!

The autonumber is only used when I need update or delete entries.

If I compact and repair would that fix it?

edit:
Access 2000

 

[racemadnss]

Ok, Well I sorda fixed it.

Since the autonumber cursor was set at 25000 I realized that I needed to trick it to thinking it was adding a new autonumber 20,000 times.

So so I set up a macro that created a new entry in the Table 20,000 times and let it run. It successfully pushed the autonumber cursor past the 45000 mark so it wont run into any duplication problems anymore....I hope.

I still dont know how it got reset to 25000 in the first place, if anyone knows or has a theory please share.

Thanks