?
Solved

VB 6 and Access 2000

Posted on 2003-03-29
5
Medium Priority
?
166 Views
Last Modified: 2010-05-01
I'm want to upgrade my databases from Access 97 to 2000 but have not been able to get connected via VB.  When I run my apps I get this message:

Run-time error '-2147319779 (8002801d)':
Automation error
Library not Registered.


It hangs up on the second line of code below:

Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TempEmp3.mdb"

Can somebody offer a suggestions?

Thanks
0
Comment
Question by:richknapp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 12

Accepted Solution

by:
jyokum earned 300 total points
ID: 8231643
make sure you have a reference to "Microsoft ActiveX Data Objects 2.x Library"

If you already do, try installing/reinstalling a newer version of MDAC.
0
 
LVL 12

Expert Comment

by:jyokum
ID: 8231647
by the way, the "2.x" would be different depending on which version of MDAC you have.
0
 

Expert Comment

by:CleanupPing
ID: 8531353
Hi richknapp,
This old question (QID 20567575) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
LVL 12

Expert Comment

by:jyokum
ID: 9301539
richknapp,
This has been open 161 days and there hasn't been a comment added in 114 days.
Please select a comment as the solution or give us an update.
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 9440701
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Accept jyokum's comment as Answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month9 days, 19 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question