Set command-line options for starting Access

Start Microsoft Access with command-line options from the Microsoft Windows Start menu

1. Click the Windows Start button, point to Settings, and then click Taskbar & Start Menu.
2. Click the Advanced tab, and then click Add.
3. In the Create Shortcut dialog box, specify a path to the Microsoft Access program file, or click Browse. It's located by default in C:\Program Files\Microsoft Office\Office10.
4. Click to the right of the Access startup command in the box where you type the location of the item, and then type the desired command-line options.

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

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

   Search Windows Help for "adding shortcuts" for more information.

Start Microsoft Access with command-line options using a shortcut

1. Open the folder where Microsoft Access is installed (located by default in C:\Program Files\Microsoft Office\Office10).
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 and opens the Northwind sample database for exclusive access.

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

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 Microsoft Windows Help for "adding shortcuts" for more information.

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