Method to reset Autonumber back to 1?

OrangeEDC

Registered User.
Local time
Today, 10:21
Joined
Dec 29, 2002
Messages
17
I created a new database with two tables. (1) is a contact table; (2) is a call for service table.

While I was trying to work out the bugs I input 10 records into the Contact Table and 10 Records into the call for DService Table.

Now, Everything works and I want the AutoNumbers to start at Record #1 (Not Record #11)

So, my question is: Is there a way to reset the Autonumber? If not, what would be the easiest way to create a new DB without having to recreate new tables, forms and queries?

Thanks for the assistance.
 
Colin;

You are The Man!! Thank you.
 

Users who are viewing this thread

Back
Top Bottom