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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…