获取MS Access ADO混合查询的完整MS SQL server错误消息详细信息

我正在使用ADO执行查询:

Dim connLocal As ADODB.Connection

    Set connLocal = CurrentProject.Connection

    strSQL = "INSERT INTO dbo_tbl_ErrorLog SELECT tbl_ErrorLog.* FROM tbl_ErrorLog;"

    On Error GoTo ErrorSQL
    connLocal.Execute strSQL
    .....
ErrorSQL:
    lErrNo = Err.Number
    strErrDesc = Err.Description
    If InStr(1, strErrDesc, "ODBC") Then
        Dim i As Long
        Dim strErr As String
        For i = 0 To connLocal.Errors.Count - 1
            strErrDesc = strErrDesc & vbCrLf & connRemote.Errors(i).Number & " - " & connLocal.Errors(i).Description
        Next i
    End If
    .....

dbo_tbl_ErrorLog 链接到MS SQL表, tbl_ErrorLog -链接MS访问表。

-2147467259-ODBC--调用失败。

connLocal.Errors 仅包含一项“ODBC--调用失败”。在这种混合查询的情况下,是否可以检索完整的错误详细信息?