Reset Autonumber?

ox0069

Registered User.
Local time
Today, 02:41
Joined
Sep 14, 2004
Messages
11
Is there any way to reset the autonumber in a table.

The situation is this, I've been creating a database (Duh) and Ive been filling the table with test information, now that all the bugs have been whacked out of the system, i want to reset all the tables to 1.

Help
 
The AutoNumber should be used as a unique identifier and to link to other tables. There shouldn't be any need to reset it as the users don't see it.

Col
 

Users who are viewing this thread

Back
Top Bottom