ADOCE can generate both ADO errors and SQL errors. ADOCE errors occur when the methods and properties of the ADOCE control are used improperly, such as trying to update a read-only recordset. SQL errors are generated when there is an error in the SQL statements used in the Open method.
You can use the On Error Resume Next statement along with inline error trapping to catch errors. After you perform an operation, check for errors inline by looking at the Err object to see if Err.Number is nonzero. Using the error code returned in Err.Number, you can handle each error appropriately.
Filtering errors can occur when moving a database between the desktop and a device using ActiveSync 3.0 or the ADOCE API functions.