auto number

P

PhilR

I have a database that uses an autonumber field as the key. I am getting an
overflow error because the auto number has hit 32,768. What is my best
option? Data is added to the table via a form and via an append query from a
batch data feed.
 
V

Van T. Dinh

It doesn't sound like an AutoNumber Field since AutoNumber Field uses 4
bytes to store the data and the possible range is (approx.) -2 billion to +2
billion.

Check the Design of the Table and confirm that the DataType is AutoNumber.
If it is, the problem is likely to be in your Append Query or your code.
 
Top