Forum Discussion
Query formula crashes Access
early_steve There are a couple of possibilities. One is corruption in the accdb. That might be corrected by compiling the VBA and doing a compact and repair on the accdb.
The other is missing references. Check those in your accdb. If one is flagged as "MISSING", that'll be the culprit.
George Hepworth Good suggestions. I should have mentioned that in investigating the issue, I tried a number of system type things, including checking for Office updates, creating a blank database, importing everything, recompiling, relinking all linked tables, and updating all references. I also copied one of the tables into a fresh temp table separate from the rest of the data structure and ran one of the queries on that.
You are giving me an idea: maybe I need to troubleshoot of reinstall Office. More likely, however, if no one else has had this issue, then I will finish skirting around the handful of queries that crashed the system.