Solved

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

Posted on 2010-08-31
19
1,442 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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

685 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