DefaultUser, DefaultPassword Properties

Applies To

DBEngine Object.

DefaultUser — sets the user name used by the Microsoft Jet database engine when it is initialized.
DefaultPassword — sets the password used by the Microsoft Jet database engine when it is initialized.

Settings

The setting for user name can be 1–20 characters long and can include alphabetic characters, accented characters, numbers, spaces, and symbols except for: " (quotation marks), / (forward slash), \ (backslash), [ ] (brackets), : (colon), | (pipe), < (less-than sign), > (greater-than sign), + (plus sign), = (equal sign), ; (semicolon), , ( comma), ? (question mark), * (asterisk), leading spaces, and control characters (ASCII 00 to ASCII 31).

The setting for password can be up to 14 characters long and can contain any character except ASCII 0. The data type is String.

Remarks

User names aren't usually case-sensitive; however, if you're re-creating a user account that was deleted or created in a different workgroup, the user name must be an exact case-sensitive match of the original name. Passwords are case-sensitive.

Typically, the CreateWorkspace method is used to create a Workspace object with a given user name and password. However, for backward compatibility with earlier versions and for convenience when secured databases aren't being used, the Jet engine automatically creates a default Workspace object when needed if one isn't already open. In this case, the DefaultUser and DefaultPassword property values define the user and password for the default Workspace object.

By default, the DefaultUser property is set to "admin" and the DefaultPassword property is set to a zero-length string ("").

For this property to take effect, it should be set before any data access functions are called.