How do I kill user connections to an Access Database?

Hello,

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13277-how-do-i-kill-user-connections.html
I need to kill user connections to an Access database to do maintenance, but
cannot find how ANYWHERE. Any help will be greatly appreciated!

-Darren

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

There's nothing built into Access to allow you to do this.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277

Take a look at http://support.microsoft.com/?id=128814 for what you can
build into your application.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277

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


"Darren" wrote in message
news:328029B3-F247-4618-9B36-51E47B84CBBC@microsoft.com...
> Hello,
>
> I need to kill user connections to an Access database to do maintenance,
> but
> cannot find how ANYWHERE. Any help will be greatly appreciated!
>
> -Darren

Darren wrote:
> Hello,
>
> I need to kill user connections to an Access database to do
> maintenance, but cannot find how ANYWHERE. Any help will be greatly
> appreciated!
>
> -Darren

http://support.microsoft.com/?id=128814

http://www.datastrat.com/Download2.html


--
Joseph Meehan
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277

Dia duit

Thanks for the INCREDIBLY quick replies. I do not wish to have sessions time
out, as this is an on-call application that is hit frequently by my team for
long periods of time. Is there a type of trigger button I could put on a
form that clears all users from the database?

"Douglas J. Steele" wrote:

> There's nothing built into Access to allow you to do this.
>
> Take a look at http://support.microsoft.com/?id=128814 for what you can
> build into your application.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
> (no private e-mails, please)
>
>
> "Darren" wrote in message
> news:328029B3-F247-4618-9B36-51E47B84CBBC@microsoft.com...
> > Hello,
> >
> > I need to kill user connections to an Access database to do maintenance,
> > but
> > cannot find how ANYWHERE. Any help will be greatly appreciated!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
> >
> > -Darren
>
>
>

Darren wrote:
> Thanks for the INCREDIBLY quick replies. I do not wish to have
> sessions time out, as this is an on-call application that is hit
> frequently by my team for long periods of time. Is there a type of
> trigger button I could put on a form that clears all users from the
> database?

The only sure-fire way to boot them is via a network admin that disconnects them
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
from the file server, and depending on what they are doing that could corrupt
your file.

--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Darren wrote:

>Thanks for the INCREDIBLY quick replies. I do not wish to have sessions time
>out, as this is an on-call application that is hit frequently by my team for
>long periods of time. Is there a type of trigger button I could put on a
>form that clears all users from the database?

In the KB article 128814 the timer is set for 1000 milliseconds or
every second. Although the IDLEMINUTES is set for 5 minutes. Thus
that code is being executed every second. Now you can check the value
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
of some data in a table somewhere and abruptly kick people out.

However if you were to do that I'd bump the timer to at least ten
seconds just to ensure the app is swamping the server with traffic
from multiple workstations.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Darren wrote:

>I need to kill user connections to an Access database to do maintenance, but
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
>cannot find how ANYWHERE. Any help will be greatly appreciated!

Why would you want to do so?

Are you wanting to update the front end as it is a shared FE residing
on the server?

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Actually, this might sound silly, but the way you do this is to ask all
users to log out....

You can actually go into the server, and display who has the file opened,
and actually CHOP the user....

However, doing the above is nearly the same as un-plugging the machine while
the user is working. So, don't use the file admin tools to chop out users
that are connected, as you will simply blow out (corrupt) your data file...

Users MUST be shut down in a orderly, and graceful manor, else you risk data
not being saved, and as mentioned a much worse issue of user damaging the
data file..

I explain with some nice diagrams as to why corruption will occur if you
don't allow the user to finish up their writing of data here

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277

It is also assumed you split your applciation....I expalin this here

http://www.members.shaw.ca/AlbertKal...plit/index.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

I've built applications that check the value of a flag in a table every time
a form is opened. If the flag is set appropriately, they're kicked out of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
the database. You can combine that with the Timer checking every x minutes.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Darren" wrote in message
news:AB103CA9-16AD-4BE3-8DC6-E78BE72BF36E@microsoft.com...
> Thanks for the INCREDIBLY quick replies. I do not wish to have sessions
> time
> out, as this is an on-call application that is hit frequently by my team
> for
> long periods of time. Is there a type of trigger button I could put on a
> form that clears all users from the database?
>
> "Douglas J. Steele" wrote:
>
>> There's nothing built into Access to allow you to do this.
>>
>> Take a look at http://support.microsoft.com/?id=128814 for what you can
>> build into your application.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Darren" wrote in message
>> news:328029B3-F247-4618-9B36-51E47B84CBBC@microsoft.com...
>> > Hello,
>> >
>> > I need to kill user connections to an Access database to do
>> > maintenance,
>> > but
>> > cannot find how ANYWHERE. Any help will be greatly appreciated!
>> >
>> > -Darren
>>
>>
>>