MS Access "system resource exceeded" error message RRS feed

  • Question

  • In MS Access 2007-2010 I have been getting the error message "system resource exceeded" when querying a database about 1.3GB large that consists of one table of 6.794 million records and tables linked to it from other databases. The query itself is rather simple as the linked table of interest contains only 3815 records that are to retrieve matches from the large table.

    My PC has 64GB of RAM on 4 chips and has been strong for me.

    I have run "compact and repair database" numerous times but the query continues to fail and the message persists.


    Tuesday, June 20, 2017 7:36 PM

All replies