Prev: Access 2007 - Export a Report
Next: Export query to Excel fails
From: Richard65 on 19 Apr 2010 17:42
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.
From: John W. Vinson on 19 Apr 2010 19:15
On Mon, 19 Apr 2010 14:42:01 -0700, Richard65
<Richard65(a)discussions.microsoft.com> wrote:

>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.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Access 2007 - Export a Report
Next: Export query to Excel fails