By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

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

P: 1
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?
Jun 18 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.