Reopen the database for relogon

[mike]

I have security on my DB and it works great until I leave the computer. How
can I get it to go back to the logon screen. I don't want to have anyone use
my logon. I have a button to exit access when I am done, but someone might
want to look something up and I need to have them use their own logon.

 

[Douglas J. Steele]

You have to close the application and re-open it.

 

[mike]

Is there a way to do it programmaticaly so I hit a button and it closes the
database and reopens it?

 

[Keith Wilby]

Is there a way to do it programmaticaly so I hit a button and it closes
the
database and reopens it?

There's no logic to what you're asking. How can code run in a closed app?
Close the app when you don't need it and have your other user(s) open/close
it as required.

Keith.
www.keithwilby.com

 

[Scott McDaniel]

Is there a way to do it programmaticaly so I hit a button and it closes the
database and reopens it?

You can use Michael Kaplan's SOON (Shut One, Open New) utility:

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com