I recently split a database using the wizard. One of my Tables has an auto-number field for the key. I had changed it to an Auto-Number from a text field some time ago using an append query. When I split the database last night, the Autonumber field was at 24222. Now it gives me 26112 as the next number.
I copied the structure of the table to a new table.
erased the the 26112 record in the source table.
appended all records from source table to new table.
when I add a new record to the new table, I get 26113. I expected 24223.
My problem is that after splitting the database, the autonumber field sequence has jumped to 26112 from 24222. Why? And is there a way back?