Click here to Skip to main content
Search within:



Next

how to increase ms access database size? i using access2007.
Sign Up to vote bad
good
See more: .NETSQL-ServerAccess
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:47
sandeep nagabhairava1.5K
Edited 28 Jun '12 - 21:05
Sandeep Mewara473K
v2
Add a Solution


1 solution

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 | :WTF:
http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]
  Permalink  
Posted 28 Jun '12 - 20:57
OriginalGriff737K
Comments
sandeep nagabhairava - 29 Jun '12 - 3:13
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:31
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.
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 375
1 Sergey Alexandrovich Kryukov 173
2 Abhinav S 168
3 Guirec Le Bars 120
4 Ron Beyer 100
0 Sergey Alexandrovich Kryukov 8,439
1 OriginalGriff 6,681
2 CPallini 3,553
3 Rohan Leuva 2,793
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web02 | 2.6.130516.1 | Last Updated 29 Jun 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid