compacting autonumber field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 11 Jan 2004 16:17 GMT

In my Autonumber fileds there some gaps between numbers - probably because
of deleted records - how do I compact the table? The database
utility-compact does not do this

Reply to this Message

Cheryl Fischer - 11 Jan 2004 16:52 GMT

Once used, an AutoNumber value is not used again, and the Compact/Repair
utility was not designed nor intended to restore them.

If you must reset your AutoNumber values, do a search at
http://groups.google.com using reset autonumber field as a search
criterion. You will get at least 2000 'hits' on the subject.

--
Cheryl Fischer
Law/Sys Associates

> In my Autonumber fileds there some gaps between numbers - probably because
> of deleted records - how do I compact the table? The database
> utility-compact does not do this

Reply to this Message

Duane Hookom - 11 Jan 2004 18:03 GMT

Cheryl is correct. I would add that you should consider not ever showing the
autonumber to users so it doesn't make any difference what an autonumber
value contains. I never use the autonumber for any reason other than to
create a unique identifier for a record.

Signature

Duane Hookom
MS Access MVP

> Once used, an AutoNumber value is not used again, and the Compact/Repair
> utility was not designed nor intended to restore them.
[quoted text clipped - 9 lines]
> > of deleted records - how do I compact the table? The database
> > utility-compact does not do this

Reply to this Message