Mikayla
asked on
Missing Reference - Converting from 97 to 2000, Excel into Access
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!
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!
Richie_Simonetti
Yes, you could install mdac software fro Microsoft.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a llok at this if you want to "upgrade" to ADO:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrworkingwithdataaccesscomponentsofofficesolution.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrworkingwithdataaccesscomponentsofofficesolution.asp
Hi,
MS-Access 2000 doesnot support the DAO 2.5/3.5 Compatibility Library. It supports only DAO 4.0 Compatibility Library. Try to update ur VB Code. You have to modify the code while Opening a Connecion Object. Change the DAO version 3.5 to 4.0 while opening a Connection object. I think this will solve ur problem.
MS-Access 2000 doesnot support the DAO 2.5/3.5 Compatibility Library. It supports only DAO 4.0 Compatibility Library. Try to update ur VB Code. You have to modify the code while Opening a Connecion Object. Change the DAO version 3.5 to 4.0 while opening a Connection object. I think this will solve ur problem.
ASKER
That worked! Thank you so much...I'll be able to sleep much better tonight!!
mani_m_in right in the first part, wrong in the second. You are confusing the OLEDB provider 3.51 and 4.0 with the DAO library. The correct version for Access 2000 of the DAO library is 3.6 rather than 3.5 or lower.
To resolve the issue you should be able to uncheck the references to the 2.5/3.5 compatibility library and check the 3.6 library instead.
To resolve the issue you should be able to uncheck the references to the 2.5/3.5 compatibility library and check the 3.6 library instead.
Thanks for "A" grade.