running access 2007 in batch file

[Richard65]

How do i run access 2007 in a batch file? Even with an autoexec macro, i keep
getting the "Getting started with Microsoft Access" screen" and I have to
click on the database name to get the autoexec to run.

 

[John W. Vinson]

How do i run access 2007 in a batch file? Even with an autoexec macro, i keep
getting the "Getting started with Microsoft Access" screen" and I have to
click on the database name to get the autoexec to run.

Use a command line to open the database, and use the /x switch to execute a
specified startup macro:

"C:\Program Files\\Microsoft Office\Office14\msaccess.exe"
"somepath\mydata.accdb" /x Macroname

or the appropriate changes to file and path names.