Maximum number of rows in a table?

I have a table with over 20 million rows. Will Access 2010 be able to handle it if it is less than 2 gig in size? Will I still be able to join it to other tables in queries?

Looked for an answer in Microsoft published specifications and could not find it.

Thanks.

March 5th, 2015 3:55pm
In theory, Access can handle such large tables. But running a query will probably be slow, especially if you have complex joins and/or conditions
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2015 4:06pm

In Addition to Hans' answer you might want to increase the MaxLocksPerFile setting because i'm pretty sure you will encounter issues with that. One explanation on how to do that can be this one:

http://www.ehow.com/how_8504332_increase-microsoft-access-max-locks.html

Maurice

March 5th, 2015 5:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics