Close db but don’t quit Access 1

[Du2good]

Is there code that can be used with a button that will close the db but leave Access open, something that maybe will close the database window, instead of hiding it?

I have user level security applied to several db using same workgroup with Access 2003.
Problem is that I'm frequently exiting one db and opening another. The db's have a button to close the db and quit Access. I've discovered that if I close the db window, Access doesn’t quit and I can open another db without logging in again.

I'd like to add a second hidden button and leave the other button the same for the other users. Everything I've found so far, either hides the database window or ends up quitting Access, instead of closing the db and leaving Access open.

 

[PHV]

CloseCurrentDatabase

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Du2good]

Thanks PHV, I appreciate it as always.
It works great, but I'm a bit sheepish as it seems so plain to me now.