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
Solved

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

Posted on 2010-08-31
19
1,440 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

829 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