G
Guest
How do I make the Autonumber adjust automatically to a deleted record? when I delete on record it does not adjust the other records to reflect the new numbering.
SandTiger said:How do I make the Autonumber adjust automatically to a deleted
record? when I delete on record it does not adjust the other records
to reflect the new numbering.
when I delete on record it does not adjust the other records to reflect theSandTiger said:How do I make the Autonumber adjust automatically to a deleted record?
when I delete on record it does not adjust the other records to reflect theSandTiger said:How do I make the Autonumber adjust automatically to a deleted record?
You can recover the deleted Autonumbers by performing a compact.
deleted how should I go about doing that?SandTIger said:Thanks for the reply Dirk.
So if I do need a record number that adjusts with each record added or
Arvin said:If you insist on having a sequential number, you'll have to code your own.
Be prepared for some serious coding to handle situations when someone
deletes a record in the middle of the data set.
the customers who are added to our database. This number needs to be alwaysSandTiger said:Thanks for the replies guys. I really appretiate your help.
What I'm trying to do is simply have a sequential number (1,2,3,...) for
instead of multiple ones because I'm trying to keep it simple.(If you get aI'm just starting with Access so I made one big table with all the fields
Steve Schapel said:Only for Access 97 and earlier versions, and then only for deletions
at the "end" of the table.
else needs it or that they don't have a function already made to deal withSandTiger said:Really!!? It seemes such a simple thing to do. I'm surprised that no one
SandTiger said:Thanks for the replies guys. I really appretiate your help.
What I'm trying to do is simply have a sequential number (1,2,3,...)
for the customers who are added to our database. This number needs
to be always in sequence even after we delete records so that we can
always know how many customers we have at any given point.
I think there was only a specific version of Access 2000 or of Jet that
wouldn't reclaim trailing autonumbers. I'm pretty sure that was fixed
in a subsequent release.