I MISSING RECORD BY AUTO NUMBER( HOW I CAN GET BACK )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I HAVE TABLE FOR CUSTOMERS WITH AUTO NUMBER SEQUENCE FROM
1969,1970,1971,1972,1974 BY I DELETE BY MISTAKE 1973 HOW I CAN FIX THE
SEUQENCE
 
Do a search of this group (or any other Access related group) and you'll
find this type of autonumber question asked repeatedly. You have a basic
misunderstanding of the field type. Autonumber is supposed to be a handy
way of generating a unique ID for each record, and usually makes for a great
primary key. It is NOT designed to give a serial sequence, and should NOT
be used/viewed as a meaningful value.

Short answer, you cannot fix the sequence, unless you convert the autonumber
field to "long integer" then manually reenter the missing values. By doing
so, you will not be able to convert back to autonumber, but there are many
available routines to calculate a serialized sequence.
-Ed
 
Ed,
The philosophy is right, but the practical advice is wrong, you can insert
numbers in the sequence with an autonumber field. e.g.

currentdb.Execute "INSERT INTO Table7([ID], [x]) VALUES (4,4)

SAMPER,
Despite what I say above about this being practically possible, I would
emphatically agree with Ed that using Autonumber in the way you appear to be
doing is not the right way to use it.
 
Back
Top