Forum Discussion
system resources exceeded error
i have been using access for many, many years and am using a current office 365 version (2009) with windows fully up to date on an lenovo thinkpad with 32gb ram etc. while i had sporadically gotten t...
I just had this problem in Access 2010 32 and 64 bit. It came up when displaying a report whose query spanned 3 mid to large size tables. The report record source was updated dynamically in the report_open code. My workaround was - created a new empty saved query. Changed it's recordset type to snapshot (I think that did the trick of consuming less resources and performing better) and then changed the report_open code to save the dynamic sql string into the new query, and then set it as the reports' recordsource. Hope this helps