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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How many records can an Access Table / Database hold
- Thread starter knighty03
- Start date
Hi
See Specification in help for various maximums etc
Basically it is not the number or rows which is an issue, it is the database size. The limits depend on the version, but (from memory) limits are 1gb for A97, 2gb for A2000/A2002.
There are various limits eg number of columns in a table, as I say see Specification in help it will give you a complete list
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
See Specification in help for various maximums etc
Basically it is not the number or rows which is an issue, it is the database size. The limits depend on the version, but (from memory) limits are 1gb for A97, 2gb for A2000/A2002.
There are various limits eg number of columns in a table, as I say see Specification in help it will give you a complete list
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question
- Locked
- Question