Reference: http://support.microsoft.com/kb/209207
The following table lists the Microsoft Access command-line options.
Option Effect Applies to
-----------------------------------------------------------------
database Opens the specified Microsoft Access Access
database or Microsoft Access project. database or
Include a path if necessary. If you are Access
running Windows 95, the default path is project
your My Documents folder.
/excl Opens the specified Access database for Access
exclusive access. To open the database database
for shared access in a multiuser only
environment, omit this option.
/ro Opens the specified Access database or Access
Access project for read-only access. database or
Access
project
/user Starts Access using the specified user Access
user name name. database
only
/pwd Starts Access using the specified Access
password password. database
only
/profile Starts Access using the options in the Access
user specified user profile instead of the database or
profile standard Microsoft Windows registry Access
settings created when you installed project
Access. This replaces the /ini option
used in versions of Access earlier
than Access 97 to specify an
initialization file.
/compact Compacts and repairs the Access Access
target database, or compacts the Access project, database or
database or specified before the /compact option and Access
target then closes Access. If you omit a target project
Access file name following the /compact option,
project the file is compacted to the original
name and folder. To compact to a different
name, specify a target file. If you don't
include a path in target database or target
Access project, the target file is created
in your My Documents folder by default. In
an Access project, this option compacts
the Access project (.adp) file but not the
SQL Server database.
/repair Repairs the Access database specified Access
before the /repair option and then database
closesAccess. In Access 2000, compact only
and repair functionality is combined
under /compact. The /repair option is
supported for backward compatibility.
/convert Converts an Access database in an Access
target earlier version to an Access 2000 database
database database with a new name and then closes only
Access. Specify the source database
before using the /convert option.
/x macro Starts Access and runs the specified Access
macro. Another way to run a macro when database or
you open a database is to use an Access
AutoExec macro. project
/cmd Specifies that what follows on the Access
command line is the value that will be database or
returned by the Command function. This Access
option must be the last option on the project
command line. You can use a semicolon (;)
as an alternative to /cmd.
/nostartup Starts Access without displaying the Access
startup dialog box (the second dialog database or
box that you see when you start Access). Access
project
/wrkgrp Starts Access using the specified Access
workgroup workgroup information file. database
information only
file
/runtime Starts Access in run-time mode. Accesss
database or
Access
project
Notes
- To run a Visual Basic for Applications procedure when you open a database, use the RunCode action in the AutoExec macro or in the macro that you run by using the command-line option /x. You can also run a Visual Basic procedure when you open a database by creating a form with a Visual Basic procedure defined for its OnOpen event. Designate this form as the startup form by right-clicking the Database window, clicking Startup, and then entering that form in the Display Form/Page box.
- To specify a forward slash (/) or semicolon (;) on the command line, type the character twice. For example, to specify the password ;mjs/md on the command line, type ;;mjs//md following the /pwd command-line option.
- Examples:
You can type the following command in the Run dialog box to open an Access 2000 database in exclusive mode that runs the specified macro at the startup:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\Program Files\Microsoft Office\Office\samples\northwind.mdb" /Excl /X Add Products
To open an Access 2002 database in exclusive mode that runs the specified macro at the startup, type the following command in the Run dialog box:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe" "C:\Program Files\Microsoft Office\Office10\samples\northwind.mdb" /Excl /X Add Products
Similarly, if you want to open an Access 2003 database in exclusive mode that runs the specified macro at the startup, type the following command in the Run dialog box:
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Program Files\Microsoft Office\Office11\samples\northwind.mdb" /Excl /X Add Products