Then I will create a append query using the old table, OldTbl, as a source.
As a new table, it has an autonumber field and it is already seeded and incrementing correctly. I’ve found that when this occurs, I create a new table, NewTbl, using the structure only method. I think that you are doing too much to recover the autonumber of a table in the article ‘AW #9.16 – Recovering from an AutoNumber disaster’. You will get a dialog saying that Access can’t add the record, and asking if you want to run the query anyway. Run the following append query: INSERT INTO tblContacts ( ContactID ) I have received several more solutions to the AutoNumber problem discussed previously with the Access Archon article “Recovering from an AutoNumber Disaster.” With these solutions, and the ones in the last AW, you should be able to find some solution that works for you, if you encounter this problem.ĭan Goldman makes the following suggestion: More solutions to Access AutoNumber problems. Thanks for joining us! You'll get a welcome message in a few moments.
