Regina Whipp

The difficult I do immediately, the impossible takes a little bit longer.

Miscellaneous

Command Line Switches for Opening Databases

Specifying a workgroup file:

             /wrkgrp "$(AppPath)\YourWorkgroup.mdw" "$(AppPath)\YourDatabase.mdb"

 

Compacting the database:

             /Compact "$(AppPath)\YourDatabase.mdb"

 

Repairing the database:

             /Repair "$(AppPath)\YourDatabase.mdb"

 

Running a database in run-time mode:

             "c:\Program Files\Microsoft Office 2003\Office\msaccess.exe" /runtime "YourDriveLetter:\MainFolder\YourDatabase.mdb"

 

Running a database for exclusive access:

             /excl "$(AppPath)\YourDatabase.mdb"

 

Running a database for read-only:

             /ro "$(AppPath)\YourDatabase.mdb"

 

Starts Access without displaying the startup dialog box (the second dialog you see when you start access):

             /nostartup "$(AppPath)\YourDatabase.mdb"

 

Starts Access using a specified user name:

             /user user name "$(AppPath)\YourDatabase.mdb"

 

Starts Access using a specified password:

             /pwd password "$(AppPath)\YourDatabase.mdb"

 

 

 

Note:  In these examples, note that you do not enclose the switches in quotation marks.  You only enclose the paths in quotation marks.