Locked Computer

[Pietro]

Hi,

How can i detect if the computer is locked through MS Access,I need it
urgently as it's the base on which I'll st up my program.

 

[Walter Goldschmidt]

How do I change the view of the control panel so I can see all options. It
does not show power options. Thanks for any reply.
Walt

 

[Burden]

Hi,

  How can i detect if the computer is locked through MS Access,I need it
urgently as it's the base on which I'll st up my program.

What do you mean?

Don't understand the question.

 

[Burden]

How do I change the view of the control panel so I can see all options. It
does not show power options. Thanks for any reply.
Walt







- Show quoted text -

Depends on what operating system you are using.

 

[Pietro]

I mean that i want to run an append query if the computer is locked ..
My company computers are set up to be automatically locked after 10 minutes
if users don't touvh them

 

[a a r o n _ k e m p f]

good stuff... you're surely barking up the wrong tree

it would be easy to do something like this is you used a database that
had a profiler feature.
then you could 'see' which users have not run anything (select,
update, insert-- whatever you wanted to test for) and then react
accordingly.

select * from sysprocesses would get you close I think. (if you were
just using the worlds most popular database-- SQL Server)

 

[Pietro]

No,it'll run...
The computer is locked,means that the user should press on Cntrl+Alt+Delete
to put the password and unlock it,it's nothing to do with the append query !

Do you have an idea about how to do this ?

 

[a a r o n _ k e m p f]

yes. From the server side-- with SQL Agent.

run profiler and you can SEE when Susie last ran something in the
database.
Welcome to the 90s.

No,it'll run...
The computer is locked,means that the user should press on Cntrl+Alt+Delete
to put the password and unlock it,it's nothing to do with the append query !

Do you have an idea about how to do this ?

Your append query won't run when the computer is locked.  Cuz it's locked.

Chris
Microsoft MVP

 

[Bob Larson]

Miss Aaron - Go kill yourself - it would do the world a favor.

yes. From the server side-- with SQL Agent.

run profiler and you can SEE when Susie last ran something in the
database.
Welcome to the 90s.

No,it'll run...
The computer is locked,means that the user should press on
Cntrl+Alt+Delete
to put the password and unlock it,it's nothing to do with the append query
!

Do you have an idea about how to do this ?

Your append query won't run when the computer is locked. Cuz it's
locked.

Chris
Microsoft MVP