Easier Solution!
This error is caused by the MACRO Security Settings within Access. To resolve the issue on the machine where it occurs...:
1) Open MS Access and from teh menu bar, select Tools --> Macro --> Security.
2) Check the "Low" checkbox on the Security Levels tab.
3) Close MS Access...