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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto number in an existing table 4
autonumber incrementing with gaps once a record is deleted 4
Data Entry Form and Auto Number ID 2
Auto Number reset to 1 16
Auto numbering 1
Auto-Increment Issue (couldn't find this one) 4
MS Access problem 0
Auto Numbering 5

Back
Top