Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8646
  • 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 MVP, Access and Data Platform)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
 
rfportillaCommented:
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 PowellAuthor Commented:
Thanks guys!  That answered my question.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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