Autonumber

  • Thread starter Thread starter jayfischer91
  • Start date Start date
J

jayfischer91

I have an access table that I am doing alot of deletes and inserts in
chunks. My question is when does the autonumber run out of
autonumbers? How large of a number can be in an autonumber field?

Thank You for your help with this!
 
Jay,

An incremental Autonumber will go to 2147483647 after which it will jump
to -2147483648 and count back up to 0. Should keep you going for a while?
 
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

Trouble with Query Results 11
Links in Query results 3
INSERT INTO With AutoNumber field 3
Append query - Append to table with Autonumber field 2
Append Query: SQL to add a new record? 7
Update the values in a table from another table 1
query that brings a autonumber field 6
Create table query... want to insert autonumber column 3

Back
Top