I have something similar going on. I have a simple vba running in a hidden form, found it in a tutorial. Works great on some databases we've got running and I get an error for others:
"On timer you enter as an event property setting produced the fiollowing error: Error accessing file. Network...