autonumber

[Guest]

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?

 

[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]...

 

[Joseph Meehan]

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?

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.

I might add that you may want to do a repair and compact of your
database at this time.