Solved

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

Posted on 2010-08-31
19
1,452 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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: 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

696 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