Complex Queries Causing Program to Close

  • Thread starter Thread starter AD
  • Start date Start date
A

AD

It appears to be an XP issue, as I never had this error
prior to upgrading, and I haven't changed my query
writing. IT Help Desk in my firm cannot figure it out -
even after sending it to the Access person there. They
have claimed that the database is corrupt, but after
rebuilding from scratch, I will go on working for a bit
and it will close on me again. Even happens if I build
databases not related to what I built before. What
appears to be triggering it is any type of complex query
logic: e.g. iif/then statements. Access will let me build
them and run them, but after I try to save it, it will
close out the whole program. Sometimes it will let me
save it, but if I go back to try to run it, or open in
design view, it closes me out. Latest one is that it lets
me run it, but doesn't let me open it in design view. Any
ideas? Anyone run across this? I've tried to reload all
XP and it still happens.
 
First thing to check is what service packs you have on your computer. Your
msaccess.exe (office folder) should be at least 10.0.6501, and your
msjet40.dll (windows\system32 folder) should be 4.0.8618. As an example of
one of these issues, see:
ACC2002: Access Quits Unexpectedly When You Run a Query
at:
http://support.microsoft.com/?id=319491

What about the SQL statement? Some subqueries can cause Access to crash, and
we found we had to just work around those by stacking one query on top of
another instead.
 
Allen

THANK YOU, THANK YOU, THANK YOU. You have no idea how
great that information is. It worked!
 
Back
Top