O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

F.1. Connection.Execute Method Options

The following tables list the enumeration values that you can specify for the Command.Execute method's options argument.

F.1.1. CommandTypeEnum Members

The CommandType enumeration specifies how the Connection.CommandText argument is to be interpreted.

MemberValueDescription
adCmdUnspecified−1Hidden. No command type is specified.
adCmdText1The CommandText argument is a command or the name of a stored procedure.
adCmdTable2The CommandText argument is the name of a table.
adCmdStoredProc4The CommandText argument is the name of a stored procedure.
adCmdUnknown8Default. The type of command in the CommandType argument is unknown.
adCmdFile256The CommandText argument is the name of a stored recordset (Recordset.Open or Requery methods only).
adCmdTableDirect512The CommandText argument is the name of a table (Recordset.Open or Requery methods only). This option cannot be combined with adAsyncExecute.

F.1.2. ExecuteOptionEnum Members

The ExecuteOption enumeration specifies how the provider is to execute the Connection.CommandText argument.

MemberValueDescription
adOptionUnspecified−1Hidden. The Command is not Specified.
adAsyncExecute16The command executes asynchronously. This option cannot be combined with adCmdTableDirect.
adAsyncFetch32The rows that remain to be retrieved after those specified by the CacheSize property are to be retrieved asynchronously.
adAsyncFetchNonBlocking64The main thread never blocks while retrieving data, so if the requested row ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required