Access Queries In ADO

  • Thread starter Thread starter Brendan Reynolds
  • Start date Start date
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"
 
Hi

Does anyone know if you can run Access "queries" with ADO.

TIA

Michael Butler
Bath Abbott Corporate Hospitality
(e-mail address removed)
 
Back
Top