Re: How to zero autonumber

Daniel

I agree that Autonumbers are not designed for use by humans, but
"unreliable" implies that they are not to be trusted to do what they ARE
designed to do.

If my chain saw does a poor job of driving nails, does that make it
unreliable?<g>

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Daniel" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D8FBC18-6BE4-44FF-9F2D-61CE6A2D7D3D@xxxxxxxxxxxxxxxx
Take a look at http://support.microsoft.com/?id=812718

Secondly, why would this be necessary? You should not be relying on an
autonumbeer field as as squential guide. If you need a number to used for
sorting... you should create it yourself and not rely on autonumbers for
this.

"You shouldn't use an autonumber if you care what the value of the field
is.
It's unreliable -- records are guaranteed to be unique, but not
necessarily
sequential or consecutive. Much, much better to manually generate the
number when the record is appended. " - taken from another forum. For
more
info Google the subject you will get lots of information.

Daniel







"Eric Blitzer" wrote:

Delete all the records then compact the database. record numbers will
start
at 1 again.

"bob6003" wrote:

In a database, can you tell me how to change the autonumber back to
zero
after deleting all fields?

Thanks

.

Relevant Pages

  • Re: How to zero autonumber
    ... "Jeff Boyce" wrote: ... I agree that Autonumbers are not designed for use by humans, ... Microsoft IT Academy Program Mentor ... autonumbeer field as as squential guide. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: AutoNumber for Primary Key
    ... There was a flaw in Access/JET where it would give duplicate autonumbers ... Microsoft did address this issue in the JET ... > for the primary keys. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: synchronising two sites
    ... replication newsgroup for future reference. ... Another approach might be to add a single field to the table ... ... own Autonumbers, so a CustomerNumber sounds like a good idea. ... Microsoft IT Academy Program Mentor ...
    (microsoft.public.access.externaldata)
Loading