Restore Deleted AutoNumber
By Richard Rost 3 years ago
Restore AutoNumbers for Deleted Records
In this Microsoft Access tutorial, you will learn how to restore AutoNumbers for records that have been deleted. Whether you accidentally deleted them, or the records became corrupted, you may need to get their IDs back. This video will show you how.
Samantha asks, "I’m in tears. I accidentally deleted a customer. I have a backup and can add his record to the table, but he gets a new AutoNumber. Is there a way to restore his old Customer ID so I don’t have to re-enter ALL of his orders, contacts, etc."
I'll show you how to restore a bunch of records from a backup table, how to write SQL and VBA to automate the process, how to increment your "final" AutoNumber, and we'll see how to use Referential Integrity to prevent accidental deletion in the future.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Restore Deleted AutoNumber
Get notifications when this page is updated