Running Access 2007 with VB

[JReagan]

I want to run a password encrypted Access 2007 Database using a VB file through my scheduled tasks. Any idea how I can do this? I can't seem to get past the part of what to when it asks for the password (I do have the password though). Any thoughts?

Jim

 

[Mr. B]

Look in the Access help file for Startup Parameters or Command Line. One of the options is to provide the Password in the command line.

 

[JReagan]

I guess what I'm asking for is an example of a code you would use. Basically where the schedule tasks opens this .vbs file, what code would I type for this to work?

Jim