Shortcut Options

The shortcut options specify which shortcuts should be created automatically when the database solution is installed, as well as any functionality for the shortcuts, such as custom icons, startup macros, and command options. The following table describes each of these options.

Option

Description

Install Location

Provides the option of creating Windows shortcuts to the database solution on the Start menu, the Desktop, or both.

Shortcut Name

Name that will be used for the shortcut that is created.

Icon

Icon that will be used for the application as well as the shortcut.

Startup Macro

Name of the macro that will be run when the database solution is launched from the shortcut.

VBA Command values Command-line arguments to be specified with the database solution.

The following table describes the available command-line switches for Access. To use these, place the switch and any required parameters in the VBA command value field. Placing text in the Startup Macro field automatically adds the /x switch and the macro's name to the command line.

Switch

Description

/runtime

Forces the application to always open in runtime mode. If both Access and the Access Runtime are installed on the machine, then, by default, the application opens in the full version of Access. This is not required if the database solution is installed as an ACCDR file.

/excl

Forces the application to always open in exclusive mode. By default, the application opens in the shared mode without the switch.

/ro

Forces the application to always open in Read-Only mode.

/user

Specifies the user name for a database that is secured by User Level Security. This must be followed by the particular user's name string, such as BackupUser. This setting has no effect for an ACCDB file because User Level Security in not supported in ACCDB file format.

/pwd

Specifies the password for a particular user of a database that is secured by User Level Security. This must be followed by the particular password string, such as Password. This setting has no effect for an ACCDB file because User-Level Security is not supported in ACCDB file format.

/x

Executes a named macro on startup of the application. The switch must be followed by the name string of a macro that exists in the Access application.

Note: Another way to run a macro when the application is invoked is to use the AutoExec macro. Any macro named AutoExec in the database is executed automatically when the database is launched and does not require this switch to be set.

Table continues on the next page

Table continues on the next page

Switch Description

/wrkgrp Specifies a custom System.MDW file for the Workgroup file to be used for the

MDB file format database solution. If this is set for the shortcut, you most likely need to include a custom System.MDW file with the application, which can be done on the third page of the wizard. Setting this switch has no effect for an ACCDB file, which doesn't support User-Level Security.

/cmd Specifies any command-line arguments that the application needs during startup. All strings that come after this switch on the command line are passed into Access and can be used from VBA code at any time.

Click Next to continue.

0 0

Post a comment