Primary Key

A

Ann

Hi

To anyone who can help..

I have been designing a small database for someone who
wants to keep track of Training Courses booked. While
setting this up I have been using sample data so that now
my booking number starts at 37 instead of 1. When I give
this database over to the person that will be using it I
want it to start counting again at 1 - is this possible?

Many thanks

Ann
 
D

DDM

Ann, of course yours is an Access question; but since you asked, delete all
your sample data and compact the database (Tools > Database Utilities >
Compact and Repair). That will reset your AutoNumbering to 1.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Top