Delete Data & Reset AutoNumbers for Blank Database

In this Microsoft Access tutorial, I will show you how to reset your database by deleting existing data and resetting auto number fields to start from one. This is especially useful if you need to create a blank copy of your database for distribution or demonstration purposes. We'll begin with a manual method suitable for beginners, then explore a more advanced technique using VBA to automate the process. You'll learn how to ensure your data is backed up, delete records from tables, and use Access's compact and repair feature to reset auto numbers, providing a fresh database experience for new users.

Richard from Concord, North Carolina (a Silver Member) asks: I made this database for personal use, but now others want to use it too. How can I delete all the records to make the tables fresh again and reset the AutoNumber fields to start over from 1?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

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!

Prerequisites

• Access Beginner 1
• Backup Access
• Compact & Repair

Links

• AutoNumbers Are NOT For You
• Delete Query
• Intro to VBA
• Status Box

Recommended Courses

• Access Courses
• Access Advanced 1
• Access Developer Courses

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 Diamond Sponsors - Information on our Sponsors 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.

Keywords

TechHelp Access, reset auto number, delete database records, compact and repair, Access developer trick, Access macro for delete, SQL delete query, VBA compact database, Access backup database, compact and repair in VBA, delete queries with macros, Access compact and repair, database reset button, auto number reset tutorial, Access developer method