auto number in table

  • Thread starter Thread starter Maileen
  • Start date Start date
M

Maileen

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
 
Maileen said:
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 ?
Click to expand...

Compact the MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top