Hello Forum Members,
I'm experiencing an intermittent problem. I have Microsoft Access 2010 front-end and Sql2008 back-end. Every once in a while, I get an error while running the following pass-through query and report:
DocName = "rptGrossFieldSummary"
Set qdfList = db.QueryDefs("qrySp_GrossFieldSummary")
strSQL = "exec sp_GrossFieldSummary '" & Application.CurrentUser &
"','" & Me.Title.Value & "','" & Me.Lease_Fraction & "'"
qdfList.SQL = strSQL
DoCmd.OpenReport DocName, acNormal 'Run Gross Field Report
The above pass-through query and report runs the majority of the time with no problems. However, at times, it fails, displaying the following error message:
"record error (-7711); there is no message for this error."
prior to displaying the error, the system hangs for awhile, as thou its waiting for the back-end connection and then times out after reaching its time limit. I checked the report's "ODBC Timeout" parameter on the Report Query properties screen and it's set to 60 secs.
Has anyone ever experienced the above error/problem? Please Advise.
Thank You,
Cliff.
I'm experiencing an intermittent problem. I have Microsoft Access 2010 front-end and Sql2008 back-end. Every once in a while, I get an error while running the following pass-through query and report:
DocName = "rptGrossFieldSummary"
Set qdfList = db.QueryDefs("qrySp_GrossFieldSummary")
strSQL = "exec sp_GrossFieldSummary '" & Application.CurrentUser &
"','" & Me.Title.Value & "','" & Me.Lease_Fraction & "'"
qdfList.SQL = strSQL
DoCmd.OpenReport DocName, acNormal 'Run Gross Field Report
The above pass-through query and report runs the majority of the time with no problems. However, at times, it fails, displaying the following error message:
"record error (-7711); there is no message for this error."
prior to displaying the error, the system hangs for awhile, as thou its waiting for the back-end connection and then times out after reaching its time limit. I checked the report's "ODBC Timeout" parameter on the Report Query properties screen and it's set to 60 secs.
Has anyone ever experienced the above error/problem? Please Advise.
Thank You,
Cliff.
