Reopen the database for relogon mike 12.07.2006 20:52:02 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.

Re: Reopen the database for relogon "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 12.07.2006 22:05:41 You have to close the application and re-open it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "mike" <mike[ at ]discussions.microsoft.com> wrote in message news:33D42DD8-DA26-4E57-AFB8-35C026EADD46[ at ]microsoft.com... [Quoted Text] >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.

Re: Reopen the database for relogon mike 13.07.2006 10:04:03 Is there a way to do it programmaticaly so I hit a button and it closes the database and reopens it? "Douglas J. Steele" wrote: [Quoted Text] > You have to close the application and re-open it. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "mike" <mike[ at ]discussions.microsoft.com> wrote in message > news:33D42DD8-DA26-4E57-AFB8-35C026EADD46[ at ]microsoft.com... > >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. > > >

Re: Reopen the database for relogon "Keith Wilby" <here[ at ]there.com> 13.07.2006 10:36:29 "mike" <mike[ at ]discussions.microsoft.com> wrote in message news:6A69BBBF-6B71-4FFC-88D7-651F39D40EC7[ at ]microsoft.com... [Quoted Text] > 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

Re: Reopen the database for relogon Scott McDaniel <scott[ at ]NoSpam_Infotrakker.com> 13.07.2006 10:44:32 On Thu, 13 Jul 2006 03:04:03 -0700, mike <mike[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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 > >"Douglas J. Steele" wrote: > >> You have to close the application and re-open it. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "mike" <mike[ at ]discussions.microsoft.com> wrote in message >> news:33D42DD8-DA26-4E57-AFB8-35C026EADD46[ at ]microsoft.com... >> >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. >> >> >> Scott McDaniel scott[ at ]takemeout_infotrakker.com www.infotrakker.com