This is not an easy problem to solve.
The first thing to do is establish the absolute minimum steps required to
cause the problem.
Once you've done that you know the bounds of the code to check.
Then concentrating on the code identified above step through checking that
any recordssets you open are closed and set to nothing any database objects
are set to nothing (if you create them using opendatabase then close them as
well), any forms/reports opened are closed and any object variables are set
to nothing (closed if appropriate).
You can then check for testing conditions where you use the default property
instead of specifying it; e.g.
If rs.fields(0) then ' relying on the default property
instead of
If rs.fields(0).Va lue = true then ' specifying the property.
If all this fails then report back and we'll see ifanything else can be
done.
--
Terry Kreft
"Keith H." <hi**********@h ol-mac.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .
I found a post on this problem from 2004, but no one at that time
replied to it- I'm hoping to have better luck than the original author!
As the subject states, I'm running into a problem where the
msaccess.exe process does not end once a user exits a database. The
author referred to a possible connection to conditional formatting, and
I do use that feature a lot.
Any help would be appreciated...t hanks!