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?
> 
> 
> to unsubscribe send a blank email to leave-access_asp-
> 1112135Q@p...