• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1506
  • Last Modified:

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

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
JohnTall
Asked:
JohnTall
  • 10
  • 9
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Possibly a Reference issue.

VBA Editor >> Tools>> References ...

Are any listed as:

**Missing <SomeReferenceName>

?

mx
0
 
JohnTallAuthor Commented:
No, I have them all listed and checked, nothing is missing
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Does your code Compile ... Debug>>Compile

?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
JohnTallAuthor Commented:
Yes
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What is ChilkatMailMan ?  3rd Party ?  Maybe it's not supported in A2010 ?

mx
0
 
JohnTallAuthor Commented:
0
 
JohnTallAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
This is 64bit O2010 ??

That alone could be your problem.  

mx
0
 
JohnTallAuthor Commented:
windows 7 pro
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
My best guess:
It's not compatible with A2010.

Can you try their phone support:

Phone: 1-630-784-9670

Near Chicago IL
0
 
JohnTallAuthor Commented:
will try them tomorrw
0
 
JohnTallAuthor Commented:
I have contacted Chilkat support, just waiting to hear back from them.

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
ok
0
 
JohnTallAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
EE is Gold !!!
0
 
JohnTallAuthor Commented:
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
 
JohnTallAuthor Commented:
The Microsoft article I used to solve it

http://support.microsoft.com/kb/274038
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Good job ...

mx
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 10
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now