Server-side Access Database won't work for one of the client machines..why?
Posted on 2013-05-31
I have an Access Database (2007) which resides on a central server. Several employees run this database through shortcuts on their machines. All of them work great except for one lady's machine (an XP machine...most of the other client machines are Windows 7). When she runs the database, it does open and she is able to select a record through the main-form like everyone else, but at that point a "compile error: project or library cannot be found" message is displayed. Along with that message a "Str" function is highlighted (it goes into debug mode) in some of the VBA code. So this Str (convert to string) function is not being recognized on her machine. That function is run out of a standard vba reference library (which she has in her reference list). At this point, I figured this was a corrupt library and told Office to repair itself...which it did, but the problem remains still. A full reinstall of Office didn't fix the problem either (although I don't think it was removed completely first..someone else did the reinstall). So, thoughts anyone?