Solved

Late binding to Outlook error in Access 2010

Posted on 2011-02-22
6
900 Views
Last Modified: 2012-05-11
I'm getting the error
429 - ActiveX component can't create object
when using

    Dim appOutlook as object
    Set appOutlook = CreateObject("Outlook.Application")

This used to work OK but now fails whether Outlook is already running or not.
Any suggestions?
0
Comment
Question by:kentgorrell
[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
  • 2
6 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 34957896
Have you checked to see if there are any broken references?
0
 

Author Comment

by:kentgorrell
ID: 34957921
I'm using Late Binding and no no broken references.
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34958479
Is it any better if you try the following?

Chris
Dim appOutlook as object
        Set appOutlook = CreateObject("Outlook.Application", "localhost")

Open in new window

0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:kentgorrell
ID: 34959324
It's different, with your code I get
error 463 Class not registered on local machine
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34959410
Hmmm implies that there is an issue with outlook itself to me.  The problem is you say outlook is ok, will have to look into it but I am guessing a repair / re-insall type solution!

Chris
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 34959457
YUp looks like the first recommendation is a repair and then retry

Chris
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

695 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