ADO and SQL Server

Maximum Tables in SELECT Property

The Maximum Tables in SELECT property specifies the maximum number of tables allowed in the FROM clause of a SELECT statement.

Applies To
Connection Object

Syntax

object.Properties("Maximum Tables in SELECT") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Integer that specifies the maximum number of tables.

Data Type

adInteger

Modifiable

Read/write

OLE DB Property

DBPROP_MAXTABLESINSELECT

Remarks

If there is no specified limit or the limit is unknown, the Maximum Tables in SELECT property is set to zero.