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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MsAccess 2000 Table Size?
- Thread starter stellJess
- Start date
StellJess,
I don't think there is a row count limitation, as such. What is limited is the size of the mdb file, so if your table is "narrow", or contains lots of nulls, the row count can get really high--I have created tables with several hundred thousand rows without any problem (except performance). When your tables get very big, you need to use indexing very carefully.
This site has some good info on the subject:
Tranman
I don't think there is a row count limitation, as such. What is limited is the size of the mdb file, so if your table is "narrow", or contains lots of nulls, the row count can get really high--I have created tables with several hundred thousand rows without any problem (except performance). When your tables get very big, you need to use indexing very carefully.
This site has some good info on the subject:
Tranman
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question