Missing Reference - Converting from 97 to 2000, Excel into Access
Posted on 2002-05-13
I have a VB program that exports Excel data into an Access database.
Our office just upgraded to Windows 2000 (we had 97). The database converted perfectly - everything works fine. However, I am having a problem with the export program (at least, I think that's what the problem is).
When I try to run it, it gives me a message something like "can't find object or library". I did some research and found out that I am missing a DAO 2.5/3.5 Compatibility Library. My question is, can I get this library from somewhere? If I did, would that solve this problem? Or should I update my code? If I have to update my code, how do I know which lines are referencing DAO? I am a relatively inexperienced VB programmer, so any suggestions will be helpful. Thanks!