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
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top