Access Not Closing

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am using a button on my main switchboard form to close
the database and Access. While my application always
closes, sometimes Access does not. When this happens, you
have to go to windows task manager to get Access to
close. I am using DoCmd.Quit on
the buttons on-click event. This is a secured Access 97
application located on a shared network drive. A shortcut
is used to open the application and the workgroup file,
and I think this is what is causing the problem
(ie "C:Office\MSAccess.exe" "G:\Databases\MyApp.mdb" /wrkgr
p "G:\Databases\MyApp.mdw"). Also, how can I open the
database exclusivly in this senario? Create a seperate
shortcut with an "open exclusive" switch?
 
It is likely that there is some object that you created and did not
eliminate. Make sure you set all objects to Nothing in you code.
 
See my response to your previous message on this i.e.'Problem Closing
Secured Application'
 
Hi Bruce,

Bruce said:
I am using a button on my main switchboard form to close
the database and Access. While my application always
closes, sometimes Access does not. When this happens, you
have to go to windows task manager to get Access to
close.
Click to expand...

Check out
http://www.mvps.org/access/bugs/bugs0005.htm
A shortcut
is used to open the application and reference the
workgroup file
(ie "C:Office\MSAccess.exe" "G:\Databases\MyApp.mdb" /wrkgr
p "G:\Databases\MyApp.mdw"). Also, how can I open the
database exclusivly in this senario? Create a seperate
shortcut with an "open exclusive" switch?
Click to expand...

That is one way.
 
Thanks alot Joan, unfortunetly I have not had time to go
through my code because I have been looking through the
great site you sent me!
 
You can use Edit, Find to locate 'Set' statements throughout your mdb; and
then check that you have Set = nothing. Using the same find you can search
for checkbox references.

Of course, I won't apologize for sending you to a great resource!
 
Back
Top