Re: How to zero autonumber

hi Bob,

bob6003 wrote:

Can someone please tell me how to change the autonumber in a database back to zero after deleting all fields in that database?

Compact (and repair) your database, use the appropriate menu point.

mfG
--> stefan <--
.

Relevant Pages

Re: #Name? error
... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
(microsoft.public.access.forms)
Re: Form Dirty not firing
... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
(microsoft.public.access.formscoding)
Re: Join Split Database
... Correction - I was able to compact and repair; it was when I tried to import ... Make two copies of the BE file and place in separate folders on ... Best case scenario is the users will not need to use the database ...
(microsoft.public.access.gettingstarted)
Re: Invalid bookmark when entering data in a subform
... The compact and repair, decompile and compile, and importing into a new ... And here is a standard sequence to fix a problem database. ... Still in the code window, choose Compile from the Debug menu. ...
(microsoft.public.access.forms)
help with corrupt database
... I read your post below in the hope of finding help with a database that's ... I can't run the compact & repair utility now - I just get the same error. ... Do you think this file is corrupt beyond repair then? ...
(microsoft.public.access.tablesdbdesign)