I have developed an application for a client that has been running fine for a few months now, but suddenly they get the error. It happens when the application tries to run code with the String function: ipBuffer = String(lngSize, 0&). I have checked their References and none are marked as MISSING. They have the following references:
Visual Basic for Application
Microsoft Access 11.0 Object Library
MS DAO 3.6 Object Library
MS ActiveX Data Objects 2.1
MS ActiveX Plugin
As far as anyone knows, no updates or Service Pack installs have been done to either Access or the OS -- it just suddenly stopped working. They are running Access 2003 on MS XP Professional 2002 SP2. What's most troubling is that it suddenly happened to two of the users, not just one; and the fact that other users running the exact version of Access and OS have no trouble running through the code, with the same References selected. Please help! I've run out of ideas and can't find any other posts with this issue (that wasn't resolved by fixing a MISSING reference).