My client is using Access as a front end to a SQL Server database. They recently started getting ODBC – 3146 errors from time to time when running some reports. From what I can tell, this is just a generic ODBC call failed error.
I’ve tried sticking some error handling in the VB script that is launching the reports, but I am not having any luck getting extra error information.
Code looks a bit like this.
Public Function RunReports()
On Error GoTo MyErrorTrap
DoCmd.OpenReport "blah", acViewPreview
DoCmd.OpenReport "foo", acViewPreview
Dim errX As DAO.Error
Dim MyError As Error
If Errors.Count > 1 'This always seems to be 0, so no help
For Each errX In DAO.Errors 'These are empty even if dont check for Errors.Count
Debug.Print "ODBC Error"
Debug.Print "VBA Error"
'Also have tried checking DBEngine.Errors, but this is empty too
I’ve also enabled tracing on the ODBC side, but that has bogged things down way too much, and I am so far unable to recreate the ODBC error.
I am completely open for suggestions on how to diagnose this.
On Error GoTo ErrorTrap
' Execute connect code at this point
Dim myerror As Error
For Each myerror In DBEngine.Errors
If .Number <> 3146 Then
To enable this code, make sure in VBA settings that error handling is turned on.