auto number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Data Entry Form and Auto Number ID 2
Auto number 3
auto number in query 1
Auto number 3
Auto number in an existing table 4
Copying Mainform and Subform data onto new Mainform/Subform 3
Transfering form data 3
Primary Keys yes or no? 8

Back
Top