View Full Version : Refreshing the AutoNumber Field.


rpk2006
07-09-2006, 08:11 AM
I had a table with an ID field defined as AutoNumber. It contained a large number of records. When I deleted those records, and added a new record, it was alloted an ID which was an increment of the last ID when the Table was full previously.

I want that the AutoNumber ID be ReNumbered from start if any record is deleted.

Banana
07-09-2006, 08:22 AM
It's a known bug; here is an Mircosoft KB Article (http://support.microsoft.com/kb/287756/)

rpk2006
07-09-2006, 08:44 AM
I am using Access XP. Is this bug still present in Access 2003? In case I wish to shift to a newer version of Access.

Banana
07-09-2006, 08:55 AM
Apparently so.

This is the latest release.

There is a beta of 2007 you can download from Mircosoft. But it's a beta. As in something I would try out but won't release to my users.

RuralGuy
07-09-2006, 09:25 AM
Since you are concerned about the actual value created by an AutoNumber field, I suggest you read this link. Use Autonumbers properly (http://www.mvps.org/access/general/gen0025.htm)