Click here to Skip to main content
13,459,040 members
Rate this:
Please Sign up or sign in to vote.
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
Updated 28-Jun-12 21:05pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

The max limit for an Access 2007 is 2GB. You cannot exceed that.[^]
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:[^]
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:
The page includes the specs (or links to the specs) for each version.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01-2016 | 2.8.180323.1 | Last Updated 29 Jun 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100