DiamondDust
Programmer
How many records can an Access table hold? and how big can an Access DB get without bugging out?
Thank you,
Thank you,
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Easy Access Table Size Question?
- Thread starter DiamondDust
- Start date
- Status
Hi
Depends on which version of Access you are using, see Specifications in help for definitive answer, but I believe the following to be true
A97, A2K, AXP, no limit on number of rows in a table, subject to overall database size:
A97 1GB
A2K, AXP 2GB
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Depends on which version of Access you are using, see Specifications in help for definitive answer, but I believe the following to be true
A97, A2K, AXP, no limit on number of rows in a table, subject to overall database size:
A97 1GB
A2K, AXP 2GB
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question