|
||||||
|
Restore Deleted AutoNumber By Richard Rost 4 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." MembersI'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 files from class plus get access to the Code Vault. If you're not a member, Join Today! Links
|
||||||||||||||||
| |||
Keywords: TechHelp Access Replace AutoNumbers Restore AutoNumbers Deleted AutoNumbers PermaLink Restore Deleted AutoNumber in Microsoft Access |