auto number in table

message from Maileen on 06 May 2004
Hi,

One of my fields in a table is based on Auto number (Auto Increment).
After deleting, this field value can start on 6 or 2545.
how can i do to reset it automatically after a deleting on 0 ?

thanks.
Maileen
 
Tony Toews replied to Maileen on 06 May 2004
Compact the MDB.

Tony
 

Archived message: auto number in table (MS Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.