John
There is a sample database in our files called InactiveShutdown. It includes forms and shows how to use a timer event to check if the database has been idle for a given time. If so, the database closes itself.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> I've seen processes on how to remotely close a frontend but I thought I'd ask the experts on this site as to the best way to do this.
>
> It happened again yesterday, I had a user log into a frontend and edit a form (I know, don't let users edit forms, but thats the way the db was set up. I also know not to share a fe with more than one user, but...) Anyway, the user walked away from her computer leaving the fe locked up. The other user tried to get into the db but got the dreaded admin locked error. I suggested adding another fe in, but eventually the user closed the db and the issue was resolved.
>
> In the future if this happens, I want to be able to safely close that frontend. Whats the best way to do this remotely? I do not have special permissions on the server to close it.
>
> John F
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar