Access Queries In ADO

B

Brendan Reynolds

Yes, you can.

The details, of course, will depend on exactly what you're doing with the
query, and whether it is a select query or an action query. But for example
this assigns the result of a query to an ADO recordset ...

Dim rst As ADODB.Recordset

Set rst = CurrentProject.Connection.Execute "qrySomeSelectQuery"
 
Top