I am getting an error when I try to Exit Access from VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The errror I am getting when I try to Quit Access from VB or a macro is
"Cannot find the file ‘C:\qbxl\Newfrom Paul\LabCst\labcst.mdb’ (or on of its
components). Make sure the path and filename are correct and that all
required libraries are available"

I just want to exit the Application. when the macro ends. What am I
doing wrong???
 
WHen you say 'whenever you quit Access' do you mean whenever you quit out of
a specific Access application? That's my guess, in which case there is
probably a routine that gets called when Access is shutting down that is
trying to reference that filename. I would go into the VB code and try to
find 'C:\qbxl\Newfrom Paul\LabCst\labcst.mdb'. Your application may be trying
to compact or backup your database right before it closes, and it may have an
old filename hardcoded in it. That's my only guess.

Jim B
 
Jim,
The error was occurring no matter what Access application I tried
to quit.

I worked around this using the following procedure:
1. Run Windows Explorer.
2. On the Tools menu, click Folder Options.
3. Click the File Types tab.
4. In the Registered file types list, locate and then select Microsoft
Access Application. Click Advanced.
5. In the Actions list, click Open and then click Edit.
6. Click to clear the Use DDE option and then click OK.
7. In the Edit File Type dialog box, click OK.
8. In Folder Options, click Close.

Thanks for you help anyway. BobK
 
Back
Top