Primary Key

[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

 

[Frank Kabel]

Hi Ann
sounds you're not in the correct NG. sound more like a MS Access topic?

 

[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