Executing a stored query using ADO

G

GPO

I have an Access 2000 mdb that has numerous action queries
(in the queries pane of the database window). I used to be
able to run these using:

Dim qdf As DAO.QueryDef
..
..
..
qdf.Execute

or

db.exectute "qappExampleAppendQuery"

What do I do in ADO?

I've tried :

Dim cnn As ADODB.Connection

cnn.Execute "qapp_Separations0304"

but no luck. It seems to only want SQL as the command text.

GPO
 

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

Top