Ask a new question

Max No. of rows in MS Access Table

Hi all,

I am working on a statistics of log files and am trying to bring them in to Access in order to run queries on them.

I have more than 10 million lines of data. so I would like to know how many databases I will need.

Answer
Answer

There is no max. You can put the tables in a separate accdb and link to them from your front end (which has all the forms, reports, queries etc.) 

There is a maximum size of 2GB for an accdb file. But you can get around this limit by 1) using multiple back ends for data or 2) using SQL Server Express or some other data store for your tables. 

2GB can cover a lot of data. it depends on your record size and how efficiently the data is designed.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

85 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 15, 2024 Views 57,549 Applies to: