Access 2003 VBA Programmer's Reference

J.1. Connection.Execute Method Options

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

J.1.1. CommandTypeEnum Values

The CommandTypeEnum values specify how the Connection.CommandText argument is to be interpreted.

Constant	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.

J.1.2. ExecuteOptionEnum Values

The ExecuteOptionEnum values specify how the provider is to execute the Connection.CommandText argument.

Constant	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 has not been retrieved, ...