Edit

Share via

Query method (RDS)

  • Article

Applies to: Access 2013, Office 2013

Uses a valid SQL query string to return a Recordset.

Syntax

SetRecordset = DataFactory.Query(Connection, Query)

Parameters

Parameter Description
Recordset An object variable that represents a Recordset object.
DataFactory An object variable that represents an RDSServer.DataFactory object.
Connection A String value that contains the server connection information. This is similar to the Connect property.
Query A String that contains the SQL query.

Remarks

The query should use the SQL dialect of the database server. A result status is returned if there is an error with the query that was executed. The Query method doesn't perform any syntax checking on the Query string.