Problem in executing consequent queries

  • Thread starter Thread starter muster
  • Start date Start date
M

muster

I ran in a problem when executing series of queries.

Dim Cnxn As New ADODB.Connection
Cnxn.Open CurrentProject.Connection
Dim lngRA As Long, lngOptions As Long
lngOptions = adCmdStoredProc

Cnxn.Execute "qryA", lngRA, lngOptions
Cnxn.Execute "qryB", lngRA, lngOptions
Cnxn.Execute "qryC", lngRA, lngOptions
Cnxn.Execute "qryD", lngRA, lngOptions

aryA would generate tblA, qryB use tblA. qryB would give an error
saying "tblA not found, ...". But when I F5 it runs ok. Seemingly
something not been refreshed.

Any method to refresh? Option prameters? Any other hints?

Thank you,
Muster
 

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

Bug in Access Execution plan ? 1
Stored procedure in SQL + vba to return a subset in Excel based onLIKE %varchar% clause 7
Stored procedure recordset not opening 9
Problem in executing query 2
ADODB Recordset Not Loading From Parameter Query 6
Executing a stored procedure in another database using the CurrentProject.Connection 2
Pass-through Query from VBA Module in MS Access 2
"No data at execution values pending" Error 0

Back
Top