Connect method (CAO)

 
 
 

Connects to a data source.

Signature

object.Connect(Datasource [, Username] [, Password] [, Prompt])

Object

DbConnect object

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.