Starts Access by using the specified workgroup information file. Starts Access without displaying the task pane (the second dialog box that you see when you start Access). You can use a semicolon ( ) as an alternative to /cmd. This option must be the last option on the command line.

Specifies that what follows on the command line is the value that will be returned by the Command function. Another way to run a macro when you open a database is to use an AutoExec macro. Starts Access and runs the specified macro. To view the default file format, click Options You must specify the source database before you use the /convert option. The /repair option is supported for backward compatĬonverts a previous-version Access database or Access project to the default file format, renames the new file, and then closes Access.

In Microsoft Access 2000 or later, compact and repair functionality is combined under /compact. Repairs the Access database that was specified before the /repair option, and then closes Microsoft Access. If you omit a target file name following the /compact option, the file is compacted to the original name and fo compact target database or target Access projectĬompacts and repairs the Access database, or compacts the Access project that was specified before the /compact option, and then closes Access. This replaces the /ini option used in versions of Microsoft Access prior to Access 97 to specif Starts Access by using the options in the specified user profile instead of the standard Windows Registry settings created when you installed Microsoft Access. Starts Access by using the specified password. Starts Access by using the specified user name.

Opens the specified Access database or Access project for read-only access. To open the database for shared access in a multiuser environment, omit this option. Opens the specified Access database for exclusive access. Will sometimes remove old code and objects from the database and make it faster.

O'Reilly Access Database Design & Programming, 3rd Edition Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file

Examples of microsoft access database