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 ...
Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.