Results 1 to 4 of 4
  1. #1
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37

    size of databases in Access 2010

    Dear All


    What is the size of databases in Access 2010 and What is the maximum size of the records?
    Is it possible to enlarge the size of databases Access?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Access db size limit is 2GB. Cannot be changed.

    Don't know what you mean by 'size of records'?

    Review http://office.microsoft.com/en-us/ac...010341462.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    As far as enlarging the size of the database, if you're running into the 2G limit, you need to review the database design before proceeding. For instance, if you are storing huge documents and graphics files IN the database, it would be better to move them to a LAN folder and store the links to them, not the documents and graphics themselves.

    If you have nearly 2 Gig of actual data, then you should begin analysis to decompose the database into multiple smaller databases that each store information that is naturally grouped together.

    Also, consider moving older historical data into archive databases, but remember that the archives are part of your application, and must be kept up to date with any changes to the data structure, rather than left to rot.

  4. #4
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37
    Very Very Thank You All

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-08-2013, 11:56 AM
  2. Replies: 5
    Last Post: 05-03-2013, 08:00 AM
  3. Access 2010 Resources for "Web Databases"?
    By weasel7711 in forum Access
    Replies: 0
    Last Post: 09-12-2012, 02:02 PM
  4. ACCESS 2010 DB size
    By jscriptor09 in forum Access
    Replies: 1
    Last Post: 02-21-2012, 10:32 AM
  5. Replies: 3
    Last Post: 09-07-2011, 03:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums