Call stored query with ADO

[steve728]

Help!

I'm converting my code from DAO to ADO. With DAO
I simply call my stored query with:

Dim db1 as database, rs as recordset
set db1 = currentdb
set rs = db1.OpenRecordset("Stored Query")

How do I do it with ADO? Please show me the code
syntax.

Thank you!

Steve

 

[pono1]

Steve,

There are quite a few ways, which creates confusion. A couple of examples.

'read-only
Dim rst as New ADODB.Recordset
rst.Open "QueryName", CurrentProject.Connection

and

'to change data
Dim rst as New ADODB.Recordset
rst.Open "QueryName", CurrentProject.Connection, adOpenDynamic, adLockOptimistic

Regards,
Tim

 

[steve728]

Thank you!

Thank you so much. This is a great help to me!

Steve