Maximum Tables in SELECT Property
From 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.