Home All Groups Group Topic Archive Search About

Reopen the database for relogon

Author
12 Jul 2006 8:52 PM
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.

Author
12 Jul 2006 10:05 PM
Douglas J. Steele
You have to close the application and re-open it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quoteHide quote
"mike" <m***@discussions.microsoft.com> wrote in message
news:33D42DD8-DA26-4E57-AFB8-35C026EADD46@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.
Author
13 Jul 2006 10:04 AM
mike
Is there a way to do it programmaticaly so I hit a button and it closes the
database and reopens it?

Show quoteHide quote
"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" <m***@discussions.microsoft.com> wrote in message
> news:33D42DD8-DA26-4E57-AFB8-35C026EADD46@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.
>
>
>
Author
13 Jul 2006 10:36 AM
Keith Wilby
"mike" <m***@discussions.microsoft.com> wrote in message
news:6A69BBBF-6B71-4FFC-88D7-651F39D40EC7@microsoft.com...
> 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
Author
13 Jul 2006 10:44 AM
Scott McDaniel
On Thu, 13 Jul 2006 03:04:03 -0700, mike <m***@discussions.microsoft.com> wrote:

>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

Show quoteHide quote
>
>"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" <m***@discussions.microsoft.com> wrote in message
>> news:33D42DD8-DA26-4E57-AFB8-35C026EADD46@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@takemeout_infotrakker.com
www.infotrakker.com