Access™ 2007 VBA Programmer's Reference

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.

Member	Value	Description
adCmdUnspecified	−1	Hidden. No command type is specified.
adCmdText	1	The CommandText argument is a command or the name of a stored procedure.
adCmdTable	2	The CommandText argument is the name of a table.
adCmdStoredProc	4	The CommandText argument is the name of a stored procedure.
adCmdUnknown	8	Default. The type of command in the CommandType argument is unknown.
adCmdFile	256	The CommandText argument is the name of a stored recordset (Recordset.Open or Requery methods only).
adCmdTableDirect	512	The 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.

Member	Value	Description
adOptionUnspecified	−1	Hidden. The Command is not Specified.
adAsyncExecute	16	The command executes asynchronously. This option cannot be combined with adCmdTableDirect.
adAsyncFetch	32	The rows that remain to be retrieved after those specified by the CacheSize property are to be retrieved asynchronously.
adAsyncFetchNonBlocking	64	The main thread never blocks while retrieving data, so if the requested row ...