Runtime Error

[Guest]

Greetings,

I am receiving the error,"Run-time error '-2147221164 (80040154)': Class
not registered" on the following line of code:

Set con = Application.CurrentProject.Connection

This database is on another user's machine and has always worked
successfully before. However, for the last two day's this error message is
displayed. I have re-registered the file Dao350.dll, but the error still
persists.

The references I have checked are the following:
Visual Basis for Applications
Microsoft Access 9.0 Library
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft DAO 3.6 Object Library
OLE Automation

I have also uninstalled Access 2000 and reinstalled it, but to no avail.
This error message is only appearing on one user's machine. Any ideas?

Thanks in advance!

 

[JM]

Try setting a reference to Microsoft ActiveX Data Objects

dim con as adodb.connection

 

[jburke521]

Notice to all experiencing the 2147221164 (80040154) Class Not
Registered error. For that matter, anyone experiencing difficulty with
the MDAC, but can't seem to reinstall the MDAC for whatever reason.

http://www.macropool.com/en/download/mdac.html

This website has a great MDAC Repair Utility that solved the problem
for me. They also have a great in-depth troubleshooting tutorial for
further diagnosing problems with MDAC installation. Don't forget to
make a donation to them if it resolves the issue. They're providing a
great little utility there.

Tal

 

[Guest]

Make sure that you have checked the references to:
' Microsoft ActiveX Data Objects 2.8 Library
' Microsoft ADO Ext. 2.8 for DDL and Security
Or at least the first!
You can download the redistributable MDAC version at:
http://msdn.microsoft.com/data/ref/mdac/downloads/default.aspx

And also a tool that checks the version that is installed in your computer.
Also, check the installation notes:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp

I hope this helps,

Dario.