Solved

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

Posted on 2010-08-31
19
1,433 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 - Access MVP) 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 5 53
MS Access Form, Datasheet view, Toggle \ show Totals Row via VBA 8 38
Programmer 14 46
SQL Group on First occurrence 9 23
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 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

15 Experts available now in Live!

Get 1:1 Help Now