SQL property [ADO]

Applies to: Access 2013 | Access 2016

Indicates the query string used to retrieve the Recordset.

You can set the SQL property at design time in the RDS.DataControl object's OBJECT tags, or at run time in scripting code.

Parameters

• QueryString

  • A String value that contains a valid SQL data request.

• DataControl

  • An object variable that represents an RDS.DataControl object.

Remarks

In general, this is an SQL statement (using the dialect of the database server), such as . To ensure that records are matched and updated accurately, an updatable query must contain a field other than a Long Binary field or a computed field.

The SQL property is optional if a custom server-side business object retrieves the data for the client.

See also

• Access for developers forum
• Access help on support.office.com
• Access help on answers.microsoft.com
• Access forums on UtterAccess
• Access developer and VBA programming help center (FMS)
• Access posts on StackOverflow

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.