Kick another user out of Access over the network

[NSNewey]

Hi,

I am responsible for a company Access database. I often need to update the backend file when everyone’s gone home with changes and there are always some people who don’t log off and leave the database open.

Is there any way that I can close there application remotely across a network without going to their PC to do it?

 

[snyperx3]

Ive read this several times on this forum. You may search around for the specifics, but this is the general way of doing it.

1) create a table that has 1 field that specifies whether or not to boot. Say a Yes/No field.

2) create a form that is invisible and is launched at program start. this form should contain a timer, and every time the timer event is hit, you check the status of the Yes/No field. If Yes then DoCmd.Exit

-Pete

 

[NSNewey]

Easy to see when it is spelled out for you...

Thanks a lot Pete.