Connecting Tech Pros Worldwide Help | Site Map

creating a vb script or batch file to open/close an ACCESS DB in a non-fixed location

Newbie
 
Join Date: Jun 2009
Posts: 1
#1: Jun 18 '09
We run a database replication process that ultimately puts a new copy of an Access DB in a new folder (on the server harddisk) every night. The folder is programmatically named and includes the “time” so I can’t path to a file (the Access file remains the same name every day) that is in a directory that changes daily.

I am wondering if there is a batch file that can be written that looks for (like a search) the filename regardless of where it is on the harddisk?

Also, the reason for the scheduled open/close of the file is because the program that creates the file can sometimes leave a lock (*.ldb) file and opening then closing the database file gets rid of the lock. That is all I need.

Can you help or point me in the direction of someone that can?
Reply