Count

This property returns the number of errors. Occasionally an ODBC driver may return multiple errors and the first one may not be the most descriptive or accurate for solving the problem. Concatenating all the errors for the message box will give the most complete description of the problem.

Group: System Error

Syntax: vValue = SysErr.Count

vValue (Variant) is the number of errors in the collection.

Example:

Dim vCount As Variant

vCount = SysErr.Count