Close open files with a script

[Guest]

Is it possible to close open files on a W2K DC with a script or by giving
some permission? Here is my situation. Our accounting department does a
monthly close of the books. The database is Visual Fox Pro and it is on our
DC. They can't close the month unless I clear the connections to the database
and the only way I know how to do this is by going through Computer
Management --> Shared Folders --> Open Files, and then right clicking on each
file and selecting close. This is a time consuming pain in the neck. You
can't select multiple files so each one is done one by one. The database is
on our DC, so I don't want to reboot just to clear this out. I'd like to set
up some kind of script or permission that allows the Accounting Manager to
close these files so I don't need to come in early once a month to close
files. Is this even possible or am I opening a security nightmare?

 

[Stanley Jones [MSFT]]

This is definitely possible on the scripting side if you know what you are
doing. Even if you don't with a little research and leveraging Visual
Studio. you should be able to write code which closes all files on the
machine.