Is there a maximum number for an ID field for a table? I have a temporary table, where I am constantly adding and removing entries. If I set the ID to an autonumber, I'm afraid that the ID will get too big and the database will crash. However, I don't really want to go back and change my code to do a manual ID number, but I will if this could be a problem. Anyone know? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
max number for an ID
- Thread starter striker73
- Start date
LarryDeLaruelle
Technical User
Autonumber uses a Long Integer type.
Access help defines it as:
Long
(long integer) 4 bytes -2,147,483,648 to 2,147,483,647
Don't think you need to worry about running out of numbers for a long time. Larry De Laruelle
ldelaruelle@familychildrenscenter.org
Access help defines it as:
Long
(long integer) 4 bytes -2,147,483,648 to 2,147,483,647
Don't think you need to worry about running out of numbers for a long time. Larry De Laruelle
ldelaruelle@familychildrenscenter.org
- Status
Similar threads
- Locked
- Question
- Locked
- Question
