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.