MS Access Database File Size Restriction

  • Thread starter Thread starter Murray
  • Start date Start date
M

Murray

Does anyone know why there is an Access database size
limitation of 2 gigabytes? Once we reach this treshold
we're unable to update or refresh tables due to an Invalid
Argument message and the database becomes corrupted.

Is there a workaround?

Thank you,
Murray
 
Because 2GB is a lot of data for a file based database?

Have you compacted? Can you split out a large table into a separate .mdb
file and link to that?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
A workaround is to put the tables in your database into separate tables.

Then make a new table and link them all with linked tables.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Let us appeal to Microsoft to increase size limit of ms access db 23
DB Size 2
Invalid Argument 5
Unable to create/edit objects in MS Access 2007 due to security .. 1
Restricting User Access In Access 2010 Sharepoint With Hydrated Database 0
reduce Access 2007 database size 6
MS Access 2003 - "This Database is in an Unexpected state 1
File Size Limit in Access 2003 on WinXP Pro? 8

Back
Top