A couple of things about this:
1. Check to see if it somehow got set from incremental to random.
2. Autonumbers really shouldn't be used for meaningful purposes unless you
can live with whatever they give you. They only guarantee unique numbers,
and even incremental is not always going to give you what you want. If you
want true incremental numbers you should look into creating your own
numbering using DMax and adding one to the value for each record (remembering
to assign it as late in the process as possible to avoid conflicts or missing
numbers due to someone starting a record, someone else starting a record and
then the first one deciding to delete their record.
3. One other thing that can cause a jump like that is if you suddenly went
to start using Replication. Replication will not use incremental numbers,
but instead will use random numbers, both positive and negative.
I hope that helps.
--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista
