Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

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!
0
Mikayla
Asked:
Mikayla
1 Solution
 
Richie_SimonettiIT OperationsCommented:
Yes, you could install mdac software fro Microsoft.
0
 
Richie_SimonettiIT OperationsCommented:
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mani_m_inCommented:
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.
0
 
MikaylaAuthor Commented:
That worked!  Thank you so much...I'll be able to sleep much better tonight!!
0
 
TimCotteeCommented:
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.
0
 
Richie_SimonettiIT OperationsCommented:
Thanks for "A" grade.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now