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?
 
Back
Top