About Chris Schuh Expertise I have several years of schooling in this area (including post-secondary), and also several years in the work force. This is my career, and I love helping others out with computer problems. I possess excellent written communication skills which allows me to guide people through complicated solutions to their problems with relative ease.
Outside of helping people with their computer issues, I'm also a Professional Magician and a Musician. You can check me out at www.chrisschuh.com!
Question Recently you answered a question (from Assaf) regarding how to backup workstations when there were still files open. I appreciate your answer about educating the users to close the applications but in my case, the offending program (JobBoss) is closed on all stations but the .mdb and .ldb files are still open. I can go into NT server and use the menu option to manually close the files and then back the database up. Are there any VBScript commands that will do that for me so that I can run it and close them up before attempting to back up the database files?
Jerry
Answer Hi Jerry,
I don't recall answering a question like that, but I do think that there are some VB Scripting solutions that you can use. At the very worst, you could use API calls within the closing sub-routine on a form in the database, or on the file itself. I'd recommend doing it on a form though, so the call to the procedure or API is made right away and has a chance to fully run before the files are closed.
I don't have the exact calls, but I'm sure they can be researched and found on the internet.
