Programming Excel with VBA and .NET

Name

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

Synopsis

Opens the record.

Argument	Description
Source	If the record source has not already been specified, you can specify a Command, Record, or Recordset object; table; or SQL statement as the source.
ActiveConnection	If the connection has not already been specified, you can specify a Connection object or connect stiring.
Mode	If the mode has not already been specified, you can specify a ConnectModeEnum constant value that specifies the access mode. The value can be adModeRead, adModeReadWrite, adModeRecursive, adModeShareDenyNone, adModeShareDenyRead, adModeShareDenyWrite, adModeShareExclusive, adModeUnknown, adModeWrite.
CreateOptions	Lets you specify whether an existing file or directory should be opened or a new file or directory should be created.
Options	Lets you specify options for opening the record. The value can be adDelayFetchFields, adDelayFetchStream, adOpenAsync, adOpenExecuteCommand, adOpenRecordUnspecified, or adOpenOutput.
UserName	Lets you specify a username granting access to Source.
Password	Lets you specify a password for the username.