Autonumber New Values property

B

Bruce

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?
 
D

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)
 
B

Bruce

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.
 
Top