Is there a way to handle the error:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
on the form I put an error handler on the current form for when the user moves to the next one but because it is corrupted or for whatever reason the error doesn't get detected and the error still pops up with a standard access error.
I'd like to handle it and I thought the error number was 3197 but I get nothing
even msgbox err.number doesn't pop up
any suggestions?