ACC: How to Use Command-Line Switches in Microsoft Access

Last reviewed: May 8, 1997
Article ID: Q105128

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

When you run Microsoft Access from the Start menu or a shortcut, (or Program Manager or File Manager in Microsoft Windows 3.x), you can use command-line switches to modify the startup process. For example, you can open a particular database, run a macro, or supply a password.

MORE INFORMATION

Microsoft Access recognizes the following command-line switches:

In Version 1.x Only:

   /s                  Bypasses the Microsoft startup screen.

NOTE: The startup, or splash screen in Microsoft Access can also be suppressed using the Microsoft Access version 1.x Distribution Kit (ADK).

In version 2.0, the /s switch no longer applies. Instead, include the StartupScreen entry to display your own bitmap logo rather than the default Microsoft Access logo. Although this is a setting for ADT applications, this entry can also be used without the ADT. Include the following statement in your MSACC20.INI file:

   [Run-Time Options]
   StartupScreen=C:\LOGO\MYBITMAP.BMP

In Version 2.0 Only:

 /Ini <initialization file>    Starts Microsoft Access using the options in
                               the specified initialization file instead of
                               the standard MSACC20.INI file. The
                               initialization file must have the same
                               entries as the standard MSACC20.INI file.

In Microsoft Access 1.x, 2.0, 7.0, and 97:

   <database>          Opens the specified database.
   /Excl               Opens the database for exclusive access.
   /Ro                 Opens the database for read-only access.
   /User <user name>   Starts Access using the specified user name.
                       You'll be prompted for the path to Msaccess.exe.
   /Pwd <password>     Starts Access using the specified password.
                       You'll be prompted for the path to Msaccess.exe.
   /X <macro>          Starts Access and runs specified macro.
   /Cmd                Specifies what value to pass to the Command
                       function in an Access Basic procedure that is
                       called by a RunCode action in an AutoExec macro.
                       This option must be the last option on the command
                       line.

In Microsoft Access 2.0, 7.0, and 97:

 /Compact <target database>    Compacts the database specified before the
                               /Compact option and then closes Microsoft
                               Access. To compact to a different name,
                               specify a target database.
 /Repair                       Repairs the specified database and then
                               closes Microsoft Access.
 /Convert <target database>    Converts a version 1.x database to a
                               version 2.0 database,
                               with a new name, and then closes Microsoft
                               Access. Specify the source database before
                               the /Convert option.

In Microsoft Access 7.0 and 97:

 /Profile <user profile>       This replaces the /ini option used in
                               previous versions to specify an
                               initialization file. The option starts
                               Microsoft Access using the options
                               in a specified user profile instead of
                               the standard Windows Registry settings.

 /NoStartup                    This option starts Microsoft Access without
                               displaying the startup dialog box.

 /Wrkgrp <system filename>     You can start Microsoft Access with a
                               specific workgroup.

 /Runtime                      Starts Microsoft Access in run-time mode.

NOTE: To use the /Runtime switch with Microsoft Access 97, you must install the Microsoft Office 97 Developer Edition Tools (ODE) or a custom application created with the ODE on your computer.

 /Convert <target database>    Converts a database in an earlier version
                               (1.x or 2.0) to a Microsoft Access 95 or
                               97 database with a new name, and then
                               closes Microsoft Access. Specify the
                               source database before the /Convert
                               option.

For example, you could type the following command in the Run dialog box (available by choosing Run from the Program Manager File menu):

   c:\access\msaccess.exe Northwind.mdb (or NWIND.MDB in versions 1.x and
   2.0) /Excl /X Add Products

This sample syntax starts Microsoft Access, opens the Northwind (or NWIND in versions 1.x and 2.0) sample database for exclusive use, and runs the Add Products macro. Note that you must include the file name, Msaccess.exe, as shown in the example.

REFERENCES

For more information about command line switches, search the Help Index for "command-line options," or ask the Microsoft Access 97 Office Assistant.

Keywords : kbui UifOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.