Access doesn't close properly

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
Back
Top