Access doesn't close properly

[Dave]

I am using Office XP with an Access 2000 database. I
have a problem that when closing this db an MSACCESS.EXE
process is left running after its closed. I have done
some extensive testing and have found the problem occurs
even when the db is not split but only after a certain
form is opened. I do have a bit of VBA code behind this
form but I can't find anything that seems to link to this
problem. I tried all the basic fixes (recompiling,
compacting etc...) but nothing helps.

Thanks in advance for any advice.
Dave

 

[Allen Browne]

First thing to check is that you have the latest service pack for Office
2000. Help | About will tell you which service pack you have, and any later
ones are available from:
http://support.microsoft.com/support/servicepacks/

You could also try these steps, as it would appear that this form may have
corrupted, but you say a decompile didn't help:

1. In your database, open the Immediate Window (Ctrl+G) and enter:
SaveAsText acForm, "MyForm", "C:\MyForm.txt"
substituting the name of your problem form.

2. Create a new (blank) database.

3. Turn off all the Name Autocorrect options in the database (Tools |
Options | General).

4. Import all the objects except the problem form (File | Get External |
Import).

5. Load the problem form from the text file:
LoadFromText acForm, "MyForm", "C:\MyForm.txt"

6. Open the Immediate window, and choose References from the Tools menu.
Uncheck any references you don't need.

7. Compile.