autonumber

  • Thread starter Problem with autonumber
  • Start date
P

Problem with autonumber

When I add a new record to a table that has an autonumber I get 230096957
instead of 3467 which is the next number to be assigned. I though maybe they
got a virus. Any suggestions?
 
M

Mark M

Autonumbers are only meant to provide unique numbers, not sequential ones.
You should not rely on an autonumber to mean anything other than to be a
unique number to identify a record and to make it easier to join and to
search tables.

"Problem with autonumber" <Problem with
[email protected]> wrote in message
news:[email protected]...
 
Top