CurrentProject.Connection errors with Class not Registered

[rsl1216]

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]

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

? Currentproject.Connection.ConnectionString

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

 

[rsl1216]

Thanks for your reply.

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

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

 

[MarkK]

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

? CurrentProject.Path

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

 

[rsl1216]

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]

And then maybe ...

? CurrentProject.AccessConnection.ConnectionString

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

 

[MarkK]

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]

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

 

[rsl1216]

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]

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]

And what about ...

? CurrentProject.AccessConnection.ConnectionString

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

 

[rsl1216]

No, for that I get..

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

 

[rsl1216]

BTW trying 2.5 and rebooting right now.

 

[rsl1216]

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

 

[MarkK]

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]

Thank you very much for your help.

 

[MarkK]

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]

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]

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