Resetting AutoNumber field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michael Watson (michael.watson_at_bbsrc.ac.uk)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 01:41:00 -0700

Yes
Delete all the numbers you don't want
Compress the database (in tools menu I think)
Autonumber should start again.

Mick

>-----Original Message-----
>Hi,
>
>Is there any way of resetting the auto number, as I am
testing a database
>and filling it up time after time, and the numbers just
keep rising after
>i've emptied it to start again.
>
>Cheers iA
>Colin
>
>
>.
>

Relevant Pages

  • Re: Resetting AutoNumber field
    ... > Compress the database ... > Autonumber should start again. ...
    (microsoft.public.access.externaldata)
  • Re: Date / Autonumber anomaly
    ... database size alone does not necessarily cause corruption. ... Then I dropped the autonumber field and added an index to the date/time ... to generate an invoice number. ...
    (comp.databases.ms-access)
  • Re: Date / Autonumber anomaly
    ... In that case, try creating a new, empty database and importing ... corruption doesn't get carried forward because it exists in your invoice ... entering, displaying, and editing the data. ... but the intent of Autonumber is to ...
    (comp.databases.ms-access)
  • Re: Date / Autonumber anomaly
    ... the size of the database file. ... Then I dropped the autonumber field and added an index to the date/time ... primary key is defined, it assigns a sortable row identifier behind the ... to generate an invoice number. ...
    (comp.databases.ms-access)
  • Re: book publishing database--design question about tabbed forms
    ... Building a database is like building a house... ... if you care about that Autonumber then best to ... which my query and tabbed form became essentially read-only--unable to be ... click a desired tab. ...
    (microsoft.public.access.tablesdbdesign)