Microsoft Access/SQL database VBA programming development and support – Melbourne based

For professional Microsoft Access and SQL Server database developers

June, 2013

How to insert old records into an Auto Numbered table

This is an old problem that rears it’s ugly head from time-to-time. You have a transaction table which uses an automatically generated number (Auto Number) as the record ID. You have lost some records in your database due to a corruption, and you have an old backup of the database which contains the lost records. […]