Shutting Down Access XP

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

Guest

Hi.

I have a database using workgroup security. When a user logs out and the
App. has closed, the Access application remains on the Taskbar and can only
be removed by 'Ending Task'.

Right clicking and closing just sort of opens the window then minimizes it
back to the taskbar.

Can anyone tell me how to get round this? (it is working on multiple
machines so is definitely a DB issue)

Cheers,
Steve.
 
The statement used to close the database used the boolean bug referred to. I
have changed the statement to include the = True but Access is still just
minimising.

Is there a way of checking for open references and setting them to nothing
in a code loop?

Cheers,
Steve.
 
FBxiii said:
The statement used to close the database used the boolean bug referred to. I
have changed the statement to include the = True but Access is still just
minimising.

Is there a way of checking for open references and setting them to nothing
in a code loop?
Click to expand...

Not that I'm aware of. Do a search for Set statements in your code.
 
I have managed to loop through the dbengine.workspaces and close any that are
still active.

There are users in the DB at the moment so I am unable to test if this helps
in the live environment....

I will search for the Set commands, what a great idea! (There is already a
list of 6 Set ... = Nothing, but im obviously missing one somewhere)

Cheers,
Steve.
 
Back
Top