VBA, MS Access MS Access в примерах

Параметры командной строки MS Access

По материалам: https://support.microsoft.com/ru-ru/office/%D0%BF%D0%B5%D1%80%D0%B5%D0%BA%D0%BB%D1%8E%D1%87%D0%B0%D1%82%D0%B5%D0%BB%D0%B8-%D0%BA%D0%BE%D0%BC%D0%B0%D0%BD%D0%B4%D0%BD%D0%BE%D0%B9-%D1%81%D1%82%D1%80%D0%BE%D0%BA%D0%B8-%D0%B4%D0%BB%D1%8F-%D0%BF%D1%80%D0%BE%D0%B4%D1%83%D0%BA%D1%82%D0%BE%D0%B2-microsoft-office-079164cd-4ef5-4178-b235-441737deb3a6


В Microsoft Access 1.x 2.0, 7.0 и 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.
				


В Microsoft Access 2.0, 7.0 и 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.

В Microsoft Access 97 и 7.0:

 /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.
				

Примечание:
     чтобы воспользоваться параметром /Runtime в Microsoft Access 97, необходимо установить Microsoft Office 97 Developer Edition средства (ODE) или пользовательского приложения, созданные с помощью ODE на вашем компьютере.

 /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.
				



Рекомендуемый порядок параметров командной строки
The following is the order to follow when creating command-line switches for Access database shortcuts. All switches are optional.Условные обозначения:

Document conventions:
    <> - Обязательный параметр.
    <<>> - Опционально.
    {} - Supplies additional information about switch, but should not be copied into command-line

    /Runtime
    /NoStartup
    /wrkgrp <system filename>
    /User "<username>"
    /Pwd "<password>"
    /Profile <user profile> <database>
    /Excl
    /Ro
    /Repair
    /Compact <<new database>>
{Do not use with repair switch}
    /X <macro> {Not the recommended method, use "Autoexec" macro instead or startup options. Do not use with compact or repair.}
    /Cmd <value> {Must always be last. Do not use with compact or repair.}

Назад ToTop
L.E. 15.08.2021
Рейтинг@Mail.ru