By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

access database

P: n/a

Can anyone tell me the maximum records that an access table will hold?
Thanx
Franca
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
There is no specific limit.

For A2000 onwards the mdb file can be upto 2GB in size.

Regards

Peter Russell

Franca Petroce previously wrote:

Can anyone tell me the maximum records that an access table will hold?
Thanx
Franca
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #2

P: n/a
"Franca Petroce" wrote
Can anyone tell me the maximum records
that an access table will hold?


No, no one can give you that information*, because there is no limit on
number of records; the maximum size of a single table is just under 2 GB
because the maximum size of a single database is 2 GB. You can link to
tables in other databases, however, to exceed a total size of 2 GB. There's
a brief article on linking tables at
http://accdevel.tripod.com/linktabl.htm.

* From the fields and their types, you can determine
the storage requirements for the data itself, but
there is some "overhead" for pointers, and the
structure of the database, that Microsoft does not
document, so we can't even calculate an estimate.

Good luck with your project.

Larry Linson
Microsoft Access MVP
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.