How to use command-line switches in Microsoft Access
This article was previously published under Q209207
This article has been archived. It is offered "as is" and will no longer be updated.
For a Access 97 version of this article, see 105128.Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
When you run Microsoft Access from the Start menu or a shortcut menu, you can use command-line switches to modify the startup process. For example, you can open a particular database, run a macro, or supply a password.
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
- 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.
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 ProductsTo 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 ProductsSimilarly, 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
For more information about how to troubleshoot invalid page faults, click the following article number to view the article in the Microsoft Knowledge Base:
208488 How to troubleshoot invalid page faults in Microsoft Access 2000For more information about using /Pwd option , click the following article numbers to view the articles in the Microsoft Knowledge Base:
207891 Can't use /pwd option with password-protected database in Access 2000
292302 Can't use /pwd option with password-protected database in Access 2002For more information about using the switches while creating the distributable runtime package, click the following article number to view the article in the Microsoft Knowledge Base:
236519 How to write macros and switches for shortcuts in the Package and Deployment WizardFor more information about using the /convert switch, click the following article number to view the article in the Microsoft Knowledge Base:
319253 How to use command line switch /convert to convert database only into Access 2000 file formatFor more information about the problem while opening the Access database by using a custom profile, click the following article number to view the article in the Microsoft Knowledge Base:
266769 Error starting Microsoft Access 2000 with custom profileFor more information about command-line switches, click Microsoft Access Help on the Help menu, type startup command-line options in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
start up startup
Article ID: 209207 - Last Review: 12/05/2015 11:05:42 - Revision: 5.4
Microsoft Office Access 2003, Microsoft Access 2002 Standard Edition, Microsoft Access 2000 Standard Edition
- kbnosurvey kbarchive kbstartprogram kbopenfile kbhowto kbinfo kbui KB209207