How to reset the Autonum field?

[Nicolas Boucquey]

I work with Access 2002. And I want to reset the Autonum
field to deliver my application.
I tried with the method described in the Access Help
pages. This method works fine to preset the Autonum
field to a greater value but not to reset the value to
Zero.

Thanks.

Nicolas

 

[Allen Browne]

After deleting the test records, compact the database:
Tools | Database Utilities | Compact.

If that does not work, you need to get Service Pack 2 for Office 2002 from
support.microsoft.com

It is also possible to set the Seed property of the autonumber Column with
ADOX. There is an example of working with the Seed property at:
http://allenbrowne.com/ser-40.html