Description

This property returns a string description of the ODBC error. Using the SysErr.Count command you may specify the number of the error in a loop and extract each error for display to the user.

Group:  System Error

Syntax:  sDesc = SysErr.Description([vIndex])

sDesc   (String) is the error description.

vIndex  (Variant) Optional – is the error number to view. Note: this value is zero-based and defaults to 1.

Examples:

Dim sDesc As String

sDesc = SysErr.Description(0)

Dim i As Integer

For i = 0 To SysErr.Count - 1

sDesc = sDesc & SysErr.Description(i) & vbCrLf

Next