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?
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?
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.
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.
Very Very Thank You All