ReturnsRecords Property

See Also    Example    Applies To   

Sets or returns a value that indicates whether an SQL pass-through query to an external database returns records (Microsoft Jet workspaces only).

Settings and Return Values

The setting or return value is a Boolean that is True (default) if a pass-through query returns records.

Remarks

Not all SQL pass-through queries to external databases return records. For example, an SQL UPDATE statement updates records without returning records, while an SQL SELECT statement does return records. If the query returns records, set the ReturnsRecords property to True; if the query doesn't return records, set the ReturnsRecords property to False.

Note   You must set the Connect property before you set the ReturnsRecords property.