how to reset the count of an AUTONUM field?

  • Thread starter Thread starter Kevin
  • Start date Start date
Repair and Compact the database where the table is located

Or in Access 97 and down, just compact
 
Kevin said:
Hi,

How can i reset the count of an AUTONUM field?
thanks
Kevin
Click to expand...

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.
 

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

Autonum Problems 1
Suggestion for Append 3
Autonum fields jumping 1
AutoNum not incrementing 16
Creating query using multiple tables 1
Update table field by content in another field in the same table 2
Bound query field using an autonum field from bound form 1
Complex relationships needed to monitor movements of assets? 2

Back
Top