Are the fields related on the autonumber field? If so, you're SOL. You could
write a query that:
a) drops the relationships
b) moves *all* the records, in all the tables (make sure you use ORDER BY!!)
c) renames all the tables
d) recreates the relationships

But, I'd question *why* you want to do this. Surely an autonumber is just
there to provide a unique value. Why do you need it to start at 1?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Elildo Mancebo Reis" <lists@a...>
Subject: [access_asp] RES: RE: How can I restart autonumber field?


: That's what I usually do. Not good when there are relations :))
:
: Thank you, anyway...
:
: Elildo Mancebo Reis - from Brazil
:
: -----Mensagem original-----
: De: Carl E. Olsen [mailto:carl-olsen@m...]
: Enviada em: sabado, 28 de dezembro de 2002 12:35
: Para: Access ASP
: Assunto: [access_asp] RE: How can I restart autonumber field?
:
:
: Copy the table and paste it into access.  Delete the original table and
: then rename the copy to the name of the original.
:
: > -----Original Message-----
: > From: Elildo Mancebo Reis [mailto:lists@a...]
: > Sent: Saturday, December 28, 2002 8:20 AM
: > To: Access ASP
: > Subject: [access_asp] How can I restart autonumber field?
: >
: > Hi, all!
: >
: > After testing my pages I want to delete all records and set autonumber
: > field
: > "seed" to 1. How can I do it in Access?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~