OpenQuery method did not run

D

David Chase

I have code behind a button that runs queries using the OpenQuery method.
For example:

stQuery = "qappDirectDepToDedFA"
DoCmd.OpenQuery stQuery

A couple of times now, this query did not run and no error was given. Is
there any way to be sure that a query has successfully run? This query was
an append query and I was able to run it by opening it from the list of
queries in the database and it ran fine. Thank you.

David
 
M

[MVP] S.Clark

The .Execute method can return a RecordsAffected parameter.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

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

Append query autorun problem 1
Append To field name has space dash space 2
Macro runs only once from switchboard 2
Access 2010 append query to SQL is very slow 0
Make Table Query with path Parameter 1
Using "like" from an external link 1
Preventing queries opening in datasheet view 1
Openquery and execute not recognizing parameters 3

Top