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"
 
M

Michael Butler

Hi

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

TIA

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset from query 5
Using "like" query from and external link to Access 1
Read query records 3
Remvoving Null Items from an ADO Recordset prior to sending to Exc 3
Import multiple Access Queries 0
Updateing a record with a Null value field, fails? 5
use of * caracter in rst.Open strSQL 2
Make table from recordset 2

Top