Solved

Late binding to Outlook error in Access 2010

Posted on 2011-02-22
6
894 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
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now