MS Access Autonumber

  Muckle 00:09 21 Oct 04

I have been messing around testing a new database by entering records to see if it does the job, but when I delete the records, make changes to the table design and enter more records, the autonumbering dosn't reset. I am now into double figures and the DB isn't in use yet - can anyone tell me how to reset the number please?

  sat481 01:30 21 Oct 04

To reset the auto number on access you need to make a new table with one field called the same as the autonumber field and then make an Append Query. You can either find this in the help files or email me and I'll send u the full instructions.

you can only go up and not down, so you have to set it for its max and then add a few.. then set it for one below the figure u actually want..


sat481 at

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch