CurrentProject.Connection errors with Class not Registered (1 Viewer)

rsl1216 · Aug 6, 2011

Any help for this issue would be greatly appreciated.

I am running Access 2007 on XP and I am getting a class not registered error when code reaches the reference CurrentProject.Connection.
One would think that this is a library issue but when checking it seem that I have every library I would need. These are the ones I have checked in the order I have them.

Visual Basic for Applications
Microsoft Access 12.0 Objects Library
Microsoft ActiveX Data Object 2.8 Library
Microsoft ActiveX Data Object Recordset 2.8 Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft Jet and Replication Objects 2.6 Library
Microsoft OLE DB Provider for OLAP Services Dialog 8.0
Microsoft Visual Basic for Applications Extensibility 5.3

Is there something that I am missing or do I have to look elsewhere in Access?

MarkK · Aug 6, 2011

What do you get if you type this in the immediate pane?

Code:

? Currentproject.Connection.ConnectionString

It also seems very unlikely you need all those different data access strategies. Are you really using them all?

rsl1216 · Aug 7, 2011

Thanks for your reply.

I get this when I type that in the immediate pane.

Run-Time Error '-2147221164(80040154)':
Class not registered

MarkK · Aug 7, 2011

OK, that's unusual.
What about ....

Code:

? CurrentProject.Path

Just trying to isolate whether the problem is with the CurrentProject object, or is it the Connection...

rsl1216 · Aug 7, 2011

C:\RSL\Symphony\IPO\Backlog\Access\UIBuilder\Presager

For some reason this path is posting with a space in the word Presager but there is no space when it returns in the immediate window.

MarkK · Aug 7, 2011

And then maybe ...

Code:

? CurrentProject.AccessConnection.ConnectionString

... to see if you can workaround it by using the AccessConnection...
But you might have to uninstall and reinstall software???

MarkK · Aug 7, 2011

Curious too about what happens if you remove all those references...
I mean, Access you can't remove, but I don't use any of those data access models. Are you using those? Remove everything you aren't using.

MarkK · Aug 7, 2011

K, so CurrentProject is OK, it's just the Connection property... That's good.

rsl1216 · Aug 7, 2011

I removed everything but these 3. Still no luck

Visual Basic for Applications
Microsoft Access 12.0 Objects Library
Microsoft ActiveX Data Object 2.8 Library

MarkK · Aug 7, 2011

Have you rebooted your machine? Also, try Microsoft ActiveX Data Object 2.5 Library instead of 2.8. See if that does anything.
But reboot your machine for sure...

MarkK · Aug 7, 2011

And what about ...

Code:

? CurrentProject.AccessConnection.ConnectionString

... in the immediate pane? Did that fail with the same error?

rsl1216 · Aug 7, 2011

No, for that I get..

Run-time error '430'
Class does not support Automation or does not support expected interface

rsl1216 · Aug 7, 2011

BTW trying 2.5 and rebooting right now.

rsl1216 · Aug 7, 2011

Ok changed reference to 2.5 and rebooted. No luck. :~(

MarkK · Aug 7, 2011

Well, I'm out of bullets. Google search shows you're not the first person to have this issue.
Here's a link to a page that might offer solutions ..
http://www.macropool.com/en/download/mdac.html
... and there're jet service packs there too.
Best of luck,
Mark

rsl1216 · Aug 7, 2011

Thank you very much for your help.

MarkK · Aug 7, 2011

Yeah, you're welcome. Hope you get it figured.
And if you don't mind, please post back here with what your solution ends up being. Maybe the trouble you go through here can save someone else a ton of trouble later. That'd be cool.
Mark

portlandjoshua · Nov 30, 2011

I am having this same issue and have done the same exact troubleshooting. I am wondering if anyone has the fix for this yet? The weird thing is that my app was working fine a week ago. Something changed and now I get this "class not registered" error.

rsl1216 · Nov 30, 2011

I ran the office setup in repair mode and it took care of the issue.

CurrentProject.Connection errors with Class not Registered (1 Viewer)

New member

bit cruncher

New member

bit cruncher

New member

bit cruncher

bit cruncher

bit cruncher

New member

bit cruncher

bit cruncher

New member

New member

New member

bit cruncher

New member

bit cruncher

New member

New member

Similar threads

Users who are viewing this thread