PDA

View Full Version : Timed Batch file to open Access file ????



Kicker
12-22-2009, 07:12 PM
There are several parts to this issue.

First. I have an Access application that, when opens, automatically opens a form and runs a whole lot of vba. Having it auto close the application is not a problem.

Second....Is there anyway I can create a Batch file that will open the mdb file at a specified time each day? Using vba in an Excel or Access application would be easy. I am not allowed to use VB6 to "compile" an exe file which would also be easy.

I think I am going to be dead in the water on this one. To make things worse, the computer can be "on" but the user needs to be "logged off".
:dunno

geekgirlau
12-22-2009, 10:25 PM
What about using Scheduled Tasks to open the database directly?

OBP
12-23-2009, 04:51 AM
I agree with geekgirlau, I use that technique to Backup a database, although I am not sure that you guarantee that the User is logged Off.

Kicker
12-23-2009, 05:21 AM
duh.....Sometimes you get so close to a problem that the solution would bite your A$$ if it got any closer.

Thanks a bunch. I will check it with the logged off user, but there is always the "Admin" user that might be able to work.

Appreciate your efforts and quick response.