Command Line Switches...
The difficult I do immediately, the impossible takes a little bit longer.
You can use command line switches as a Shortcut or type it in to Start > Run. Your path to Access may vary depending on your Windows version and your Office version, i.e.

Windows XP...
"C:/Program Files/Microsoft Office/Office14/msaccess.exe"

Windows 7 64 bit...
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe"

Office folders, i.e.
Office 2003 - Office11
Office 2007 - Office 12
Office 2010 - Office14
Office 2013 Desktop - Office15
Office 2013 Click-to-Run - C:/Program Files (x86)/Microsoft Office 15/root/office15 or C:/Program Files/Microsoft Office 15/root/office15
Tips (Main)
Quick Access Toolbar (QAT)
Customize Toolbox Controls
Database Folder Set-Uo
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabaseName.accdb" /decompile
Running a database in Runtime mode:
"C:/Program Files/Microsoft Office/Office/msaccess.exe" /runtime "YourDriveLetter:/PathToYourDatabase/YourDatabaseName.mdb or .accdb"
Start Access without displaying the startup dialog box (the second dialog you see when you start Access):
"C:/Program Files/Microsoft Office/Office/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabase.mdb" /nostartup
Compacting a database:
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabase.accdb" /compact
Repairing a database:
Running a database for exclusive access:
Running a databse for read-only:
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabase.accdb" /repair
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabase.accdb" /excl
"C:/Program Files (x86)/Microsoft Office/Office14/msaccess.exe" "YourDriveLetter:/PathToYourDatabase/YourDatabase.mdb" /ro
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.