Close files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luis - 28 Jul 2005 09:39 GMT

Hello. I have several databases that update files on a daily basis. The
problem is that some users don't close the files when they get out of office
and the update process fails.
How can i programmatically check if the file to be updated is open and if
it's true close or kill te session?

Thanks.

Luis

Reply to this Message

Alex Dybenko - 28 Jul 2005 20:28 GMT

Hi,
first of all look here:
http://www.mvps.org/access/general/gen0034.htm

to force logoff you can use a hidden form's timer event, where you check for
a flag in some table, once it true - you give a message to user and quit
application

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hello. I have several databases that update files on a daily basis. The
> problem is that some users don't close the files when they get out of
[quoted text clipped - 6 lines]
>
> Luis

Reply to this Message