delete autonumber memory

[Guest]

After a delete query that deletes all the data in a table, I also need the
autonumber (key) reset to zero. It just keeps counting up forever. After it
gets in the 6 digit numbers it messes up my code that uses that field as part
of a file name format 0000.
Is there a way to reset this counter on the autonumber field programmatically?
thanks,
ck

 

[Arvin Meyer [MVP]]

If the table is completely empty, compacting the database will reset the
auronumber to zero.
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Marshall Barton]

After a delete query that deletes all the data in a table, I also need the
autonumber (key) reset to zero. It just keeps counting up forever. After it
gets in the 6 digit numbers it messes up my code that uses that field as part
of a file name format 0000.
Is there a way to reset this counter on the autonumber field programmatically?

After you delete the records, Compact the database.

OTOH, there is no good reason why you should care about the
value of an autonumber field. Autonumbers are only good for
creating surrogate keys and should never be displayed. If
no one can see it, then there is nothing to complain about
the values.

If you need to provide a sequential number for something
like invoice numbers, then create you own values instead of
using Autonumbers.