Access Not Closing

[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?

 

[Lynn Trapp]

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.

 

[Joan Wild]

See my response to your previous message on this i.e.'Problem Closing
Secured Application'

 

[Bruce]

Thanks Joan, but I can not find that origional message.
Can you repost your answer?

 

[Guest]

Thanks Lynn, I will look for that.

-----Original Message-----
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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm






.

 

[Joan Wild]

Hi 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.

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?

That is one way.

 

[Bruce]

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!

 

[Joan Wild]

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!