Connects to a data source.
Signature
VBA / VB.NET
object.Connect(Datasource [, Username] [, Password] [, Prompt])
- object
-
Type: DbConnect
The object or objects this method applies to.
- Datasource
-
Type: String; input-only
The name of a .udl file in the Data Links directory.
- Username
-
Type: String; input-only; optional
User name with which you are connecting.
- Password
-
Type: String; input-only; optional
Password for connecting.
- Prompt
-
Type: Boolean; input-only; optional
Specifies whether users are prompted to specify connection properties.
- TRUE: Prompts users to specify required connection properties, if some are missing.
- FALSE: Does not prompt users to specify connection properties
Remarks
If the data source is already connected, nothing happens.