How do I get detailed PostgreSQL-errors in Access via ODBC?

Question

Is there a way to get the detailed error-messages PostgreSQL shows when running a query from command-line or a client like PG-Admin when using the ODBC-Interface-Driver?

The Err-object in Access just tells you that something went wrong but is not very helpful - I have to run the same query again in PG-Admin to see where the problem is.

Answer 1

Silly me! Just have to iterate through the Errors-object...

Dim errX As DAO.Error
Dim strError As String

For Each errX In DAO.Errors
    strError = strError & "# >> " & errX.number & " | txt >> " & _
                errX.DESCRIPTION & Chr(10) & Chr(10)
Next errX