ADO: ActiveX Data Objects

Name

Record.Open Method — (Versions 2.5, 2.6)

Synopsis

record.Open  (Source, _
              ActiveConnection, _
              Mode, _
              CreateOptions, _
              Options, _
              UserName, _
              Password)

The Open method opens an individual record in a recordset or a resource within a data source.

Arguments

Source (Variant)

Optional. Indicates the source of the resource to open. This can be a URL, a Command object returning a single row, an open Recordset object, or a String containing a SQL statement or a table name.

ActiveConnection (Variant)

Optional. Indicates the connection to the data source by either a connection string or an open Connection object.

Mode (ConnectModeEnum)

Optional. Indicates the access permissions to open the Record object with. The default value is adModeUnknown.

CreateOptions (CreateModeEnum)

Optional. This argument is used only when the Source argument represents a URL. This argument can be used to indicate whether to open an existing resource or to create a new one. The default value for this argument is adFailIfNotExist.

Options (RecordOpenOptionsEnum)

Optional. Can contain multiple RecordOpenOptionsEnum enumeration values that indicate special options for opening the Record object. The default value for this method is adOpenRecordUnspecified.

UserName (String)

Optional. Indicates, if necessary, the username that will be used to access the resource indicated by the source argument.

Password (String)

Optional. Indicates, if necessary, the password to verify the UserName argument.

Description

If the Record object ...