Start Microsoft Access with command-line options using a shortcut

1. Open the folder where Microsoft Access is installed (typically the folder will be named Office in the Microsoft Office subfolder of the Program Files folder on your C drive).
   
   
2. Right-click the Microsoft Access program icon, and then click Create Shortcut.
   
   
3. Right-click the shortcut icon just created, click Properties, and then click the Shortcut tab.
   
   
4. Click to the right of the Microsoft Access startup command in the Target box, and then type the desired command-line options.

   For example, the following command line starts Microsoft Access, opens the Northwind sample database for exclusive access.

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /excl

To display the list of command-line options, click .

Note   After you create a shortcut you can put it on your desktop or in a folder, or add it to the Start menu. Search Windows Help for "shortcuts" for more information.

You can also create a shortcut to open any Microsoft Access database object directly from Windows.

For more information, click .