ActiveX component can't create object

I've got a computer that's been running Office 2003. We upgraded Outlook to version 2007. Now my Access VBA code can't communicate with Outlook. Any ideas how to fix this?
Set olApp = GetObject(, "Outlook.Application")
If TypeName(olApp) = "Nothing" Then Set olApp = CreateObject("Outlook.Application")

Open in new window

Nancy-ActiveX.bmp
LVL 4
GordonPrinceAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GordonPrinceConnect With a Mentor Author Commented:
I ran into an unrelated message on the user's computer that the Database Splitter wasn't installed. So I looked in Add/Remove Programs and saw that -- for some reason -- not all of Office 2003 was installed (application dropdowns were grey instead of white). After updated the Office 2003 installation to [Run all from my computer] on everything except Outlook (since Outlook 2007 is installed), everything started working.
0
 
apache09Commented:
Try chaning your settings in Trust Centre
Tools>Trust Centre

Try reducing the security settings in Progammatic Access and Macro Security settings.

0
 
GordonPrinceAuthor Commented:
Allowed all activity in the Trust Center -- no change. Still the same error message.
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
GordonPrinceAuthor Commented:
I think I've seen some things like this before. The solution might be in the registry, but where is the setting for how Outlook is supposed to be controlled by another program? That's just a hunch I have.
0
 
apache09Commented:
Usually other applications that access or send mail via Outlook actually use MAPIMAIL.
I would suspect that this has either been disabled after the upgrade or has become corrupt.
You may try renaming your MAPI dlls and or running FIX MAPI

http://www.ctimls.com/Support/KB/Error%20Fixes/Fix_Mapi_error.htm



0
 
BALMUKUND KESHAVCommented:
Activex Component being used by your Access App is older, either you upgrade your Access too or reinstall outlook 2003.

You can try to change activex component in Access App to latest one.

Best of luck...

Bm Keshav
0
 
apache09Commented:
Glad you got it sorted.
0
 
BALMUKUND KESHAVCommented:
Gordon Prince, can you share the solution please.

Bm Keshav
0
 
GordonPrinceAuthor Commented:
The solution is in my comment from 5/13/2009 above. All of Office 2003 was not installed.
0
All Courses

From novice to tech pro — start learning today.