Hey everyone

well i have a database that i created and used already for testing with ASP

now i want to renew the database
like i want a fresh copy of it

is that possible where all the autonumbers are set back to 1

thanks

What Comes Around Goes Around!

__________________
What Comes Around Goes Around!

Delete the records from each table, (open the table, ctrl a, Delete). Depending on how you defined table relationships and cascade deletes, you may need to delete in a particular order. Then compact the database from the tools menu and the autonumbers will be reset. In the future or even the next time for this database, make a file copy of the emptied database and just copy that copy over the 'used' copy.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]