473,322 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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
Dec 3 '07 #1
4 1524
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

Dec 3 '07 #2
On Dec 3, 2:20 pm, "Jens Schilling"
<JensSchillingBitteLoesc...@fissership.dewrote:
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
Dec 3 '07 #3
Snoopy33 <ho********@hotmail.comwrote:
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/
Dec 4 '07 #4
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

Dec 4 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mahesh Hardikar | last post by:
Hi , Oracle 8.1.7.0.0 on HP-UX 11.0 EMC2 Disk Array We are in a process of implementing DR Site using Standby Database feature of Oracle. We have tested it on 2 NT machines here & things are...
0
by: Cherrish Vaidiyan | last post by:
hello, Thanx for the suggestions on my Listener query. Now i am performing a simple work.. STANDBY DATABASE creation. I have followed the instraction from Oracle 9i Release 1 documentation...
0
by: James | last post by:
Hi , I have an oracle 8.1.6 running on solaris platform. This database have a standby DB of same version and OS platform for query or report generation. At day time the standby DB is in...
4
by: jbizzy | last post by:
SQL Users/DBAs, I'm trying to move data files around for a database that is in standby mode. I can detach/attach the database fine using SP_DETACH_DB/SP_ATTACH_DB , but when I re-attach the...
1
by: aswinee | last post by:
I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Edition on Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPU and 8GB of RAM. I have AWE enabled, /pae /3gb switch is on...
6
by: shorti | last post by:
db2 8.1 fix pack 12 on AIX 5.3 This is a newly configured HADR machine. The HADR was up and running. I was 'playing' around some on the standby and did a db2 deactivate and things sort of went...
3
by: Simon | last post by:
Hi All, I'm hoping someone will have some words of wisdom for me regarding MS Clustering on Windows 2003. I have a service that runs on a cluster. During invocation it's supposed to...
3
by: Frank Rizzo | last post by:
I have an WinForm app that sits around doing nothing most of the time. However, several times during the 24 hour period, based on a timer event, it goes and does a couple of things (connects to a...
7
by: Volkan Senguel | last post by:
Hi i'm searching a solution to avoid that the user can go in the standby mode while a app is runing. i have searched and readed a lot in the web and have not found a working solution... for the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.