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
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
General
| Tips (Main) |
| Home |
| Quick Access Toolbar (QAT) |
| Customize Toolbox Controls |
| Database Folder Set-Uo |
Decompile:
"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