OpenQuery method did not run

  • Thread starter Thread starter David Chase
  • Start date Start date
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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top