Troubleshooting

Missing Library or Project Message

I get a "The expression EventName you entered as the event property setting produced the following error: Can't find project or library" message when attempting to open or convert an Access 97 application .mdb.

The most common cause of this error message results from use of Access 97's Microsoft DAO 2.5/3.5 Compatibility Library, which permits compiling code with the remnants of Access 2.0's VBA code conventions that are incompatible with DAO 3.5+. You must update the code to DAO 3.5x standards in Access 97, and then convert the Access 97 version to Jet 4.0. To do so, substitute a reference to the Microsoft DAO 3.51 Object Library for the Microsoft DAO 2.5/3.5 Compatibility Library. Correct the unsupported syntax by repeatedly compiling the code until all modules compile and the application runs properly. Then convert the .mdb file to Access 2000 format.