Access database size limit? 2GB?

I've been receiving a "database may be corrupt" error, when trying to run a query on a large database.

The size is approximately 2GB,  and when I do a "compact and repair" on the database, it usually allows me to finalize what I was trying to do previously.

Is there a size limit on Access databases.  I thought that 2GB would be fine, but apparently not.
If I store all my data in a different Access database, and simply link to those tables...will I run into the same problem?

Thanks for any help!
LVL 1
James PowellData Analyst / Online Retail DevelopmentAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
2GB IS ... the size limit, include all System objects.
When you approach that limit, it's like approaching a black hole - seriously.

mx
0
 
rfportillaConnect With a Mentor Commented:
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"If I store all my data in a different Access database, and simply link to those tables...will I run into the same problem?"

Your app s/b split ... Front End with all objects EXCEPT tables, and a Back End - just tables.
FE is Linked to BE tables.

This likely will reduce the size ... and dramatically improve performance and reliability.

mx
0
 
James PowellData Analyst / Online Retail DevelopmentAuthor Commented:
Thanks guys!  That answered my question.
0
All Courses

From novice to tech pro — start learning today.