When I used VB6 with DAO to talk to Access97 I was able to respond to 'Cant Update Record locked' messages by trapping error 3186
Now I am using ADO with Access2002 backend, 3186 is not trapped and the error comes up as -2147217887 but with the same error message "cant update, record is locked" (or very similar).
From looking at a Microsoft Information Sheet, it says that -2147217887 is "errors occurred".
Can I not trap specific Jet Locking Errors any more??
Now I am using ADO with Access2002 backend, 3186 is not trapped and the error comes up as -2147217887 but with the same error message "cant update, record is locked" (or very similar).
From looking at a Microsoft Information Sheet, it says that -2147217887 is "errors occurred".
Can I not trap specific Jet Locking Errors any more??