Compact&Repair: Autonumbering NOT Reset

[Alan Guy]

I did a "Compact and Repair" but after that, the autonumbering was not
reset. There's only 6 records in the table: still numbered 11 thru 16
and any added new record gets numbered up in the 43,nnn,nnn range.

The auto numbered field IS a Primary Key field and .mdb is Access 2002 -
2003 file format.

Any suggestions?

TIA - Alan

 

[John Vinson]

I did a "Compact and Repair" but after that, the autonumbering was not
reset. There's only 6 records in the table: still numbered 11 thru 16
and any added new record gets numbered up in the 43,nnn,nnn range.

The auto numbered field IS a Primary Key field and .mdb is Access 2002 -
2003 file format.

Any suggestions?

Yes. Don't use Autonumber if you care what the value is. This is how
A2002 and later versions work.

An Autonumber has one purpose ONLY: to provide a meaningless unique
key.

If you want sequential gapless numbers, don't use Autonumber; use a
Long Integer and program the assignment of new numbers yourself. Do a
Google Groups search for "custom autonumber" or "custom counter" in
these groups for a plethora of examples.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Alan Guy]

Ok, then thanks very much, John . - Alan

 

[Tony Toews]

I did a "Compact and Repair" but after that, the autonumbering was not
reset. There's only 6 records in the table: still numbered 11 thru 16
and any added new record gets numbered up in the 43,nnn,nnn range.

Set AutoNumbers to start from ...
http://allenbrowne.com/ser-26.html

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm