MS Access Database File Size Restriction

[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

 

[Kevin3NF]

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

 

[TIMA]

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.