Page 1 of 1

Break server connection

Posted: 16 Aug 2011 08:03
by Yarbz
Greetings,
In my company, we are working in XP with Office 2003.
I work on a campus wide front-end/back-end MS Access database. Early each morning I have the back-end update through a scheduled batch file. It is posted everywhere to be out of the database at update time, however some people open it and forget to close it or are playing in it when it is time to update. Meaning the update fails, causing long delays and lots of unhappy people.
My question is this:
Is there a DOS script I can place in the batch file to boot everyone out of that file folder so that the update can then proceed without interruption?
Thanks
Yarbz

Re: Break server connection

Posted: 19 Sep 2011 08:43
by Yarbz
Support is not available at 0600 or 6AM. So I'm trying to do a work around to break the connection and boot everyone out of that file so it can be updated.
I was told there was a way to do it in DOS but I can't find it.
Anyone who knows how, please respond. :!:
Thanks
Yarbz

Re: Break server connection

Posted: 19 Sep 2011 14:11
by aGerman
I'm not sure whether it is available on all XP versions, but there is a command OPENFILES.

Also PsFile (downloadable here) could help.

Unfortunately I'm not familiar with those remote stuff.

Regards
aGerman