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."

Members

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.

•  Extended Cut Video - Silver

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

• Customer Database Template
• Relationships
• Access Expert Level 1:
• Update Queries
• Append Queries

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.