Kick users off immediately

[andrewf10]

Hows it going all?

Just a quick question for you experts out there.

While the excellent sample database at RogersAccessLibrary will allow me to kick a user off my database in X amount of minutes/hours, has anyone ever needed to kick a user off immediately, and therefore render the OnTimer useless?

See my users PCs are already under pressure without me running an OnTimer event every 15 or 30 minutes.

Really is a long shot I know but...

Thanks

 

[The_Doc_Man]

If your users' PCs cannot handle a timer every 15 to 30 minutes, you have a massive problem already. Access is just the tip of your iceberg.

But to answer the question, the only way to kill another user that I know of is to start something that is running in the context of your users. Anything else almost falls into the area of hacking. I.e. reach into machine X to do something to it that didn't come from the user's keyboard.

Short of some sort of networking programming to open a socket on the client end and have it establish a dialogue with your server, then have the server send messages to everyone who has an open socket, I don't know of a clean way to do this that doesn't involve breaking a state law on hacking.

 

[andrewf10]

Thanks Doc Man,

I think I'll try holding onto my job so I'll give hacking a miss.

Might test out this Timer business on only a few PCs at first because I'm having enough trouble with unreliable hardware as it is.