Solved

Error Number 429; ActiveX component can't create object; Access 2010

Posted on 2010-08-31
19
1,445 Views
Last Modified: 2012-05-10
I have code in access that creates an object to send e-mail; it used to work in access 2003, but now in Access 2010 I get the following error:

429

ActiveX component can't create object

The code is as follows:

Dim mailman As ChilkatMailMan
Set mailman = CreateObject("ChilkatMail.ChilkatMailMan")



0
Comment
Question by:JohnTall
[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
  • 10
  • 9
19 Comments
 
LVL 75
ID: 33572088
Possibly a Reference issue.

VBA Editor >> Tools>> References ...

Are any listed as:

**Missing <SomeReferenceName>

?

mx
0
 

Author Comment

by:JohnTall
ID: 33572096
No, I have them all listed and checked, nothing is missing
0
 
LVL 75
ID: 33572137
Does your code Compile ... Debug>>Compile

?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:JohnTall
ID: 33572149
Yes
0
 
LVL 75
ID: 33572172
What is ChilkatMailMan ?  3rd Party ?  Maybe it's not supported in A2010 ?

mx
0
 

Author Comment

by:JohnTall
ID: 33572231
0
 

Author Comment

by:JohnTall
ID: 33572413
I tried to follow the instr. here

http://www.cknotes.com/?p=293

and I have registered them for 64 bit, but I still have the same error.

0
 
LVL 75
ID: 33572426
This is 64bit O2010 ??

That alone could be your problem.  

mx
0
 

Author Comment

by:JohnTall
ID: 33572455
windows 7 pro
0
 
LVL 75
ID: 33572527
"and I have registered them for 64 bit, "
64 bit what?  Office ?

Can you email or call the vendor ?
Sorry, I'm kind of out of ideas ...

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 33572563
My best guess:
It's not compatible with A2010.

Can you try their phone support:

Phone: 1-630-784-9670

Near Chicago IL
0
 

Author Comment

by:JohnTall
ID: 33572912
will try them tomorrw
0
 

Author Comment

by:JohnTall
ID: 33580684
I have contacted Chilkat support, just waiting to hear back from them.

0
 
LVL 75
ID: 33580703
ok
0
 

Author Comment

by:JohnTall
ID: 33589720
They advised me to purcahse a new copy, and I did for $99.00, as I downloaded it, I couldn't get it running, even in a new database with just the sample code.

This is after registering the dll's in 32 and 64 bit modes, running as administrator.

I called support, waiting their call back.

Sometimes EE is worth more than company paid support.
0
 
LVL 75
ID: 33589750
EE is Gold !!!
0
 

Author Closing Comment

by:JohnTall
ID: 33596798
Chilkat Software tech support advised me to check their KB article, because they couldn't think of why it was not working, I found a Microsoft support article there that did not refer to this error, but I applied the logic, and it did work.

I have granted permission for the 'Everyone' group to read the value in the registry, and that just made it work.

So note that a similar error, even when the dll is in fact registered, if the user can't read the reg value, this is what you get.

Tnx to all  
0
 

Author Comment

by:JohnTall
ID: 33596817
The Microsoft article I used to solve it

http://support.microsoft.com/kb/274038
0
 
LVL 75
ID: 33597766
Good job ...

mx
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.

739 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