I have an Access application that no longer shuts down properly. The
msaccess.exe process remains running in the background. Obviously
there is some code running that causes this but I can't track it down.
I've set all my database and recordset object references to Nothing.

Access 2000 SP3.
Vista Ultimate x64 SP1.
Split database (local Access data file).

Anything else I should be looking for?

regards,
Bradley

"Br@dley" <bradley (AT) comcen (DOT) com.au> wrote:

One person mentioned wonky DLookup for which the expression field didn't cause an
error message but was really strange.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

References to checkbox controls as in

If me.NameofCheckBox Then
some code

rather than
If me.NameofCheckBox.Value Then
some code

have been known to cuase the problem you describe.


On May 21, 7:35*pm, "Br@dley" <brad... (AT) comcen (DOT) com.au> wrote:

This can be a horrible problem to resolve. You need to find the minimum
number of steps required to cause the condition and that will then narrow
down the code that runs which needs investigating.

You then can go throught this code to eliminate the usual suspects, if that
doesn't do it you need to rem out blocks of code until the problem goes away
and then investigate why the problem blocks are causing the problem.



--
Terry Kreft


"Br@dley" <bradley (AT) comcen (DOT) com.au> wrote