how to increase ms access database size? i using access2007.

Question

1.00/5 (1 vote)

See more:

hi experts,

I developed a windows application,Back end DB was access2007. i heard that Max limit of access2007 is 2GB. Now my question is, is their any way to improve access size?, how to create more than one db for a application to increasing size and performance.

Thanks in advance...

Posted 28-Jun-12 20:47pm

sandeep nagabhairava

Updated 28-Jun-12 21:05pm

Sandeep Mewara

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-06-28T20:57:00

Solution 1

The max limit for an Access 2007 is 2GB. You cannot exceed that.
http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx[^]
You would have to look at your data, and work out some way in which it could be partitioned into multiple databases.

Or, dump Access and use SQL Server instead - 2008R2 supports 10GB databases, and SQL 2012 supports up to 524,272 terabytes :WTF:
http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]

Posted 28-Jun-12 20:57pm

OriginalGriff

Comments

sandeep nagabhairava 29-Jun-12 3:13am

thanks Griff, If i turned to Access to SQL Server 2008R2,what was the minimum requirements of client,for using my application.

OriginalGriff 29-Jun-12 3:31am

Ignore the client - the minimum spec doesn't change (it may even drop compared to hosting a 2GB Access database) - it is the server hardware requirements you need to look at. MS publishes them: http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx
The page includes the specs (or links to the specs) for each version.