"Insufficient resources" error with Access

Question

Any idea on what can cause this error, everytime I execute a query?

The DB is about 2GB.

Thank you.

Answer 1

The maximum size for a single Access 2007 DB is 2GB minus the space for required System Objects. Ref.

Do you regularly compact your database? A large Access DB is often a symptom of not compacting.

Click on the round Office button that you should see in the upper left corner. Then click on Manage in the list. You should see Compact and Repair Database at the top of this listing.

[NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.]

Answer 2

You are pushing the limits of your mdb filesize: http://office.microsoft.com/en-us/access/HP051868081033.aspx