Re: Resetting AutoNumber field

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

From: Colin Basterfield (colinbasterfield_at_hotmail.com)
Date: 06/16/04 

Date: Thu, 17 Jun 2004 09:53:45 +1200

Thanks for this.

"Michael Watson" <michael.watson@bbsrc.ac.uk> wrote in message
news:1d15f01c4537d$a6cbad80$a501280a@phx.gbl...
> 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

  • Resetting AutoNumber field
    ... Compress the database ... Autonumber should start again. ... Mick ... >Is there any way of resetting the auto number, ...
    (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)