Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8894
  • Last Modified:

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!
0
James Powell
Asked:
James Powell
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
2GB IS ... the size limit, include all System objects.
When you approach that limit, it's like approaching a black hole - seriously.

mx
0
 
rfportillaCommented:
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now