Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: .NET SQL-Server Access
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
Edited 28-Jun-12 21:05pm
v2

1 solution

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

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 | :WTF:
http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]
  Permalink  
Comments
sandeep nagabhairava at 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 at 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.

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

  Print Answers RSS
0 OriginalGriff 383
1 Richard Deeming 180
2 ChauhanAjay 176
3 Sergey Alexandrovich Kryukov 171
4 Yogesh Kumar Tyagi 165
0 Sergey Alexandrovich Kryukov 6,252
1 OriginalGriff 5,498
2 CPallini 2,473
3 Richard MacCutchan 1,627
4 Abhinav S 1,530


Advertise | Privacy | Mobile
Web02 | 2.8.140821.2 | Last Updated 29 Jun 2012
Copyright © CodeProject, 1999-2014
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