System Standby locks other users out

I have just sat up a database that has 2 - 10 users at any given
time. Everything is running smooth, however when someone's computer
goes into standby it seems to lock everyone else out of the database
and prevent changes from being made.

I have a module that detects existing users and I have sat it up so
that I can kick individual users out at random, however when they go
into standby the kick feature doesn't work.

Is there a solution to this other than preventing everyone's
computers from going into standby?

Thanks
Ben

Re: System Standby locks other users out

Hi,

Maybe this a solution for you :

The sample "Detect and Logoff Idle Users" which you can find here :

http://www.candace-tripp.com/utterangel.aspx

It kick out idle users after a set time period instead of kick out at
random.

Regards
Jens


> Snoopy33 wrote:
> I have just sat up a database that has 2 - 10 users at any given
> time. Everything is running smooth, however when someone's computer
> goes into standby it seems to lock everyone else out of the database
> and prevent changes from being made.
>
> I have a module that detects existing users and I have sat it up so
> that I can kick individual users out at random, however when they go
> into standby the kick feature doesn't work.
>
> Is there a solution to this other than preventing everyone's
> computers from going into standby?
>
> Thanks
> Ben

Re: System Standby locks other users out

On Dec 3, 2:20 pm, "Jens Schilling"
wrote:
> Hi,
>
> Maybe this a solution for you :
>
> The sample "Detect and Logoff Idle Users" which you can find here :
>
> http://www.candace-tripp.com/utterangel.aspx
>
> It kick out idle users after a set time period instead of kick out at
> random.
>
> Regards
> Jens


Thanks Jen,

I have that code running in part at the moment. I have it closing an
open form after 10 minutes of idle bringing them back to the menu
screen. My thought was that it would release the lock for the table
when the form was closed....I was obviously wrong.

I believe you're right, I'll have to just have the DB shutdown all
together after 15 minutes of idle (I believe default for standby
setting is 20 minutes) and if someone wants back in, they'll have to
log back in. That should resolve my problem.

Ben

Re: System Standby locks other users out

Snoopy33 wrote:

> Is there a solution to this other than preventing everyone's
>computers from going into standby?

Possibly, you could try moving to SQL Server. Which is probably rather impractical.

Otherwise no. Change your idle detect timer to be less than the shortest duration of
standay by that users have. Make it 4 minutes. And explain to everyone why.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: System Standby locks other users out

Thanks Jen and Tony,

I changed the timer to kick users from the form back to the main menu
after 5 minutes and then to kick out totally after 9 minutes idle in
the menu which gives us up to 14 minutes of idle before being kicked
(like i said, i believe system standby is defaulted to 20 minutes on
most computers). I have already gotten grumbles about this, but have
explained that it has to be done.

once again, thanks for the help and explination, it's gone a long way
in backing my explination to be able to show people your responses.

Ben