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

What is the maximum number of records Access can hold?

P: 14
Hello,

I need to know what is the maximum number of records Access can hold?

I need approx. 6 million records, do you know if Access can hold this amount?

Thank you everyone.
Oct 11 '07 #1
Share this Question
Share on Google+
2 Replies


Jim Doherty
Expert 100+
P: 897
Hello,

I need to know what is the maximum number of records Access can hold?

I need approx. 6 million records, do you know if Access can hold this amount?

Thank you everyone.
Don't even think about it!... use SQL Server to hold the data and frontend into the database using Access if you like

Regards

Jim
Oct 11 '07 #2

nico5038
Expert 2.5K+
P: 3,072
It's a max of 2 Gb that Access can hold in one database. There's no limit on the number of records. So 6 Mb records allow for a recordsize of approx 333 characters.
There's also no limit when linking to tables in other 2 Gb databases :-)

Nic;o)
Oct 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.