Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access database size limit?  2GB?

Posted on 2014-04-15
6
Medium Priority
?
8,487 Views
Last Modified: 2014-04-15
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
Comment
Question by:James Powell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 25

Assisted Solution

by:Tony Giangreco
Tony Giangreco earned 500 total points
ID: 40002669
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 40002673
2GB IS ... the size limit, include all System objects.
When you approach that limit, it's like approaching a black hole - seriously.

mx
0
 
LVL 9

Assisted Solution

by:rfportilla
rfportilla earned 500 total points
ID: 40002677
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 75
ID: 40002680
"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
 
LVL 1

Author Comment

by:James Powell
ID: 40002685
Thanks guys!  That answered my question.
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question