When I go to Tools>References in VBA and try choosing Microsoft DAO 3.6 Object library, I get the following message: "Name conflicts with existing module, project, or object library". When I hit Access help, it tells me that:
1. There is already a module, project, or object library with this name referenced in this project, or
2. You attempted to add a reference to a project or object library whose file name (without an extension) is the same as the name of one of the current project's modules.
This has me mesmerized because neither my module (module1), nor my project, nor the object library has any name that should conflict with adding this library and to use DAO I need this reference. Any ideas why this is happening? Thanks for your help.