>>This is the code I use
>
>Just a suggestion, you will probably want to restore ON ERROR not matter what, not just when the USE fails. (Judging by the code you posted, its only resets it in one case)
Mike, I've just posted a code snippet, not the whole Load event of my form. I restore it to original state in my code after this conditional check too (if it doesn't fail). Good catch, though.
If it's not broken, fix it until it is.
My Blog