Microsoft Office Tutorials and References
In Depth Information
Tip Clearing the Err
Even though you can’t rely on the Err object for all the details about an error, you can rely
on the Err object to identify that an error has occurred. Just remember to use the Clear
method to remove any previous information in the Err object before you execute your
The Errors collection object is a typical collection object containing a Count property and an
Item property that returns an Error object. You can use a For…Each loop to process all the
items in the collection, and then use the Clear method to erase all the Error objects in the col
Note The Errors collection is populated only when an error occurs. Use the Clear method
before you execute a command to avoid detecting an error that has already been handled.
Using the Error Object
The Error object contains a number of properties that describe a specific error condition.
(See Table 23-4.) For the most part, these properties provide information about the error
from several different perspectives, which might be necessary depending on the exact cause
of the error.
Table 23-4. Key Properties of the Error Object
Contains a short text description of the error.
Contains a provider-specific error code.
Contains the OLE DB error code.
Contains the standard five-character ANSI SQL error code.
The Command Object
The Command object contains information about the task that the database will run.
Depending on the type of command you want to execute, you might also have to use the
Parameter object and the Parameters collection to execute a stored procedure.