reset auto number

[bgarey]

I have been working with accesss for a couple of years. I learned how to
reset autonumber to zero by appending a zero then deleteing files.
We have changed over to office 2003. This procedure does not reset the
autonumber in access 2003. Is there a different process that will allow me to
do this.

 

[Steve Schapel]

Bgarey,

Delete all records from the table, and then "Compact and Repair Database".

 

[bgarey]

Thanks,
That was easy and worked

Bgarey,

Delete all records from the table, and then "Compact and Repair Database".

 

[bgarey]

For the particular application that I was using autonumber is fine. There are
other places that autonumber is not ok. Where can I find out how to make
sequential numbers in access?