Close files

[Guest]

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

 

[Alex Dybenko]

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