Select the product you need help with
How to use command-line switches in Microsoft AccessArticle ID: 209207 - View products that this article applies to. This article was previously published under Q209207
For a Access 97 version of this article, see 105128 Moderate: Requires basic macro, coding, and interoperability
skills.
(http://support.microsoft.com/kb/105128/
)
.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). On This PageSummary When you run Microsoft Access from the Start menu or a shortcut menu, 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 The following table lists the Microsoft Access command-line
options. Option Effect Applies to
-----------------------------------------------------------------
database Opens the specified Microsoft Access Access
database or Microsoft Access project. database or
Include a path if necessary. If you are Access
running Windows 95, the default path is project
your My Documents folder.
/excl Opens the specified Access database for Access
exclusive access. To open the database database
for shared access in a multiuser only
environment, omit this option.
/ro Opens the specified Access database or Access
Access project for read-only access. database or
Access
project
/user Starts Access using the specified user Access
user name name. database
only
/pwd Starts Access using the specified Access
password password. database
only
/profile Starts Access using the options in the Access
user specified user profile instead of the database or
profile standard Microsoft Windows registry Access
settings created when you installed project
Access. This replaces the /ini option
used in versions of Access earlier
than Access 97 to specify an
initialization file.
/compact Compacts and repairs the Access Access
target database, or compacts the Access project, database or
database or specified before the /compact option and Access
target then closes Access. If you omit a target project
Access file name following the /compact option,
project the file is compacted to the original
name and folder. To compact to a different
name, specify a target file. If you don't
include a path in target database or target
Access project, the target file is created
in your My Documents folder by default. In
an Access project, this option compacts
the Access project (.adp) file but not the
SQL Server database.
/repair Repairs the Access database specified Access
before the /repair option and then database
closesAccess. In Access 2000, compact only
and repair functionality is combined
under /compact. The /repair option is
supported for backward compatibility.
/convert Converts an Access database in an Access
target earlier version to an Access 2000 database
database database with a new name and then closes only
Access. Specify the source database
before using the /convert option.
/x macro Starts Access and runs the specified Access
macro. Another way to run a macro when database or
you open a database is to use an Access
AutoExec macro. project
/cmd Specifies that what follows on the Access
command line is the value that will be database or
returned by the Command function. This Access
option must be the last option on the project
command line. You can use a semicolon (;)
as an alternative to /cmd.
/nostartup Starts Access without displaying the Access
startup dialog box (the second dialog database or
box that you see when you start Access). Access
project
/wrkgrp Starts Access using the specified Access
workgroup workgroup information file. database
information only
file
/runtime Starts Access in run-time mode. Accesss
database or
Access
projectNotes
References
For more information about how to troubleshoot invalid page faults, click the following article number to view the article in the Microsoft Knowledge Base:
208488
For more information about using /Pwd option , click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/208488/
)
How
to troubleshoot invalid page faults in Microsoft Access 2000
207891
(http://support.microsoft.com/kb/207891/
)
Can't use /pwd option with password-protected database in Access 2000
292302
For more information about using the switches while creating the
distributable runtime package, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/292302/
)
Can't use /pwd option with password-protected database in Access 2002
236519
For more information about using the /convert
switch, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/236519/
)
How
to write macros and switches for shortcuts in the Package and Deployment
Wizard
319253
For more information about the problem while opening the Access
database by using a custom profile, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/319253/
)
How to use command line switch /convert to convert database only into Access 2000 file format
266769
For more information about command-line switches, click Microsoft Access Help on the Help menu, type startup command-line
options in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
(http://support.microsoft.com/kb/266769/
)
Error starting Microsoft Access 2000 with custom profile
Properties | Article Translations
 |
Back to the top
