As far as I'm aware On Error Resume Next won't pcik that error up,
it's a compile error not a runtime error.

Do you really need the reference?

If other people don't have access to it then it's going to interfere
with far more than your code.

It could affect all the code the user has.

Perhaps you should look into using late binding, mind you if the users
don't have Access installed that might not be a solution either.