Autonumber New Values property

[Guest]

I converted an Access 2.0 database to Access 2003. I used the autonumber
type for a record id field. The New Values property is set to increment, but
new records do not increment this field. Instead I get either negative
numbers or very large numbers out of sequence. What is going on?

 

[david epsom dot com dot au]

You are getting 'random' instead of 'increment'.

Is the database replicated?

If you convert the type to 'random', compact the database,
reset the type to 'increment', and compact again, does it
fix the problem?

Can you try converting it first to A97, then A2003?

Can you delete the field and add a new autonumber field?


(david)

 

[Guest]

Once you go to random, you cannot change back to increment. And deleting the
field is not an option because that field is my linking field to other tables.

 

[Joseph Meehan]

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.