Connect Method
Connects to a data source.
Signature
object.Connect(Datasource [, Username] [, Password] [, Prompt])
Object
DbConnect The object or objects this method applies to.
Datasource
String; input-only
The name of a .udl file in the Data Links directory.
Username
String; input-only; optional
User name with which you are connecting.
Password
String; input-only; optional
Password for connecting.
Prompt
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.