The three essentials are VBA, Access, DAO. Unnecessary libraries waste memory, slow loading, increase the chance of problems, and hamper debugging. Use the table below to ensure you reference the correct files for your version of Access.ĭecember 2006 update: There is a new issue with bad references when running multiple versions ofĪccess on Windows Vista. Access 2007 uses the ACEDAO library to give you the new functionality in the private JET engine. For example, the DAO 3.5 library was designed for Access 97, whereas DAO 3.6 is designed for Access 2000, 2002, and 2003. Inconsistencies and data corruption can result from referencing the wrong library for your version of Access. Disambiguate each declaration, by specifying the library you intend, e.g.:.Change the priority of the DAO library, by moving it above ADO.Remove the reference to either the ADO or the DAO library.For example, the DAO and ADO libraries both have a Recordset object, so Access 20 often choke when a DAO recordset was intended. Open Access, and select the library reference again.Īmbiguities arise if libraries have objects with the same name. Regsvr32 -u "c:\program files\common files\microsoft shared\dao\dao360.dll" Issue this command, and then the one above to re-register it: Occasionally, the problem is not solved until you unregister the library and re-register it. Regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll" Include quotes if the file name contains spaces, e.g.:
Enter regsvr32 followed by the full path of the library file. Click the Windows Start button, and choose Run. If the library is not even shown, you may need to re-register it. The table below lists the files for the crucial libraries of your version of Access. If a library is marked MISSING, click the Browse button, and locate the correct file for the library. press Ctrl+G), and choose References from the Tools menu. To see what libraries an Access project has referenced, open any code window (e.g. Then simple functions like Date() or Trim() don't work.
Installing or uninstalling any software may overwrite, remove, or de-register libraries. However, adding extra libraries increases the number of things that can go wrong. If Access does not provide something you need (such as a calendar or tree-view), you may be able to find a library and add it. Access itself and its programming language (VBA) are two essential libraries in every project. Libraries are components that provide functionality. Microsoft Access tips: Solving Problems with Library References Microsoft Access Tips for Serious Users