Fix an error 429 in access VBA 2010

Question

0.00/5 (No votes)

See more:

Good evening, World !!. I'm working with an old Access 2010 application, and I'm getting an error message 429 "Activex cannot create the object".

The reference to the library is correctly registered in the references list of the project, and the file (a .TLB file) is now properly registered in windows 7. I thought doing that was enough to solve ths problem, but it still remains the same; that´s why I resort this forum (I hope is correct to say so).

I used to work a lot with VB 6 and found this problem a lot of time, but it was never this difficult to me to solve it. I have to admit my lack of experience with access.

The dll is one that a vendor gave us recently, I don´t know if it's developed in the same version of Access or what, so it could be a compatibility issue. My problem is that my bosses don´t want to deal with this vendor anymore, they had to take a legal action even to get this final component, so I have to solve this.

Here's a piece of code:

VB

Dim objProd as new ProductoTemporal ("ProductoTemporal" is a class contained in a registered DLL)
Dim Cadena as string

After the dim´s, if I put the cursor above "objProd" it shows

Quote:
"Object variable or statement width not stablished"; "Cadena" has a value ""

When the code tryes to assign a value to one property (Conexion):

VB

objProd.Conexion = Cadena  (The string variable already have the proper string connecction)

here´s when the program fails.

I would really appreciate anyone's help.

What I have tried:

I'm even trying to change the code, but it has take me a lot of time.

Posted 10-Jan-18 7:41am

Miguel Altamirano Morales

Updated 10-Jan-18 9:18am

Maciej Los

v3

Add a Solution

Comments

Maciej Los 10-Jan-18 13:53pm

Have you debug your VBA programme to find out where the error occurs?

Miguel Altamirano Morales 10-Jan-18 14:21pm

Thanks for answerig, Maciej. Yes I have done this. I have perfectly identified where. The code fails here:

objProd.Conexion = Cadena

Giving me the error number 429 "The Activex component cannot create the object".

This code is after the "Dim" statements I described in my question.

I wonder if Access needs some configuration in order to be able to create objects.

Maciej Los 10-Jan-18 14:29pm

Have you added a reference to that dll in a Tools->References window?

Miguel Altamirano Morales 10-Jan-18 14:32pm

yes, everything seems to be in order.

Miguel Altamirano Morales 10-Jan-18 14:35pm

I even can see it in the Object Browser, with all its members

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-01-10T09:13:00

Solution 1

Take a look here: ActiveX component can't create object or return reference to this object (Error 429)[^]
There you'll find the most common reasons of above error.

[EDIT]
Before you start changing anything, please, read this:
How to check and remove incorrect project references in the Visual Basic Editor in Word[^] - it's not important that this topic concerns MS Word, VBA editor is the same
Check or Add an Object Library Reference[^]

Try to change your code into below form to find out what happend.

VB

'this should be declared on the beggining of module
Option Explicit

'your soubroutine
Sub CheckMyObject

Dim objProd as ProductoTemporal

On Error Goto Err_CheckMyObject

Set objProd = New ProductTemporal

MsgBox "Object 'ProductTemporal' has been successfully created!", vbOkOnly, "Success!"

Exit_CheckMyObject:
    On Error Resume Next
    Set objProd = Nothing
    Exit Sub

Err_CheckMyObject:
    MsgBox Err.Description, vbExclamation, Err.Number
    Resume Exit_CheckMyObject

Exit Sub

Posted 10-Jan-18 9:13am

Maciej Los

Updated 10-Jan-18 20:08pm

v2

Comments

Miguel Altamirano Morales 10-Jan-18 17:35pm

Thanks for this advice Maciej; the page is a really interesting one.

Well, at least for the first two entries, it seems to me that everything is correct; - Anyway: how can I verify the class is correctly registered ?

And how could I get to know if the class has a license ?

The library was developed (I think) with VBA and we do have a license to use the entire system. I do not know if the vendor gave us a new license.

And as I told you: I'm not authorized to get in touch with the vendor.

Maciej Los 11-Jan-18 2:00am

Miguel, i'd suggest to re-register this dll in a system with Windows admin account priviledges. There's a chance that registration process will finish with success. On the other hand, try to change your code into the form i posted in updated answer.

Miguel Altamirano Morales 11-Jan-18 10:43am

Good morning Maciej, thanks again for your advice.

I already tried it and is still failing with the same error 429 when it tries to execute the instruction "Set objProd = New ProductTemporal".

I just don´t know what is happening; the library is correctly registered as far as I can see, and the references list of the project do contain this reference.

Could it be possible a compatiblity problem with a different version of this dll ?

I asked for another PC to see if it still fails on it. I also going to apply for a new version of access (2016); I´m working with access 2010.

Maciej Los 11-Jan-18 14:52pm

and the references list of the project do contain this reference - remove it and save changes then close database. After that open database again and add a reference to the new dll.

As to the MS Access - do not try to install new version.

Miguel Altamirano Morales 11-Jan-18 15:07pm

The project already has a reference to the vendor´s library, but pointing to the .tlb file. We have in effect .dll file, but the reference is added to the .tlb file. I don´t know how does these files handles between them, and if I try to add a reference to the dll, it is rejected, "A reference to this file cannot be made" (or something like this).

Please forgive me if sometimes I cannot make my self clear. English is not my native language.

The project HAS a reference to this library.

Miguel Altamirano Morales 11-Jan-18 15:08pm

that's why I just can't undestand what is hapeening. Everything seems to be correct.

Maciej Los 11-Jan-18 15:10pm

Sorry. For the first time i've read your comment incorrectly. Sorry. Please re-read my comment again.

Miguel Altamirano Morales 11-Jan-18 16:58pm

Don´t worry Maciej; I did what you suggested me and the failure remains. I got the same error.

Is it possible that it is another kind of problem ?; a permission-denied issue ?, I mean, my Access 2010 has no permissions to create new objects ?. Or something like that. This problem goes beyond Access scopeI think.
I used recently the Microsoft Excel Library 14.0 and used the command "CreateObject" to create and excel.application object, and it worked just fine.

It must be a reasonable cause for this problem.

Maciej Los 11-Jan-18 17:11pm

There's something wrong with your library. I'm pretty sure that a *.dll is not registered in GAC. Seems your dll is not normal dll, but .NET dell. So, it needs to be registered in GAC. Check this: How to: Install an Assembly into the Global Assembly Cache | Microsoft Docs[^]. More about GAC is here: Global Assembly Cache | Microsoft Docs[^]

Miguel Altamirano Morales 11-Jan-18 18:37pm

I ran the gacutil utility you suggested me and MS DOS sent me a respone:

"gacutil is not a recognizable executable file" (more or less).

I searched thru my windows explorer and a I located it on "Windows\Microsoft.net\Framework\V1.1.4322", but I noticed it is named "gacutil.exe.config" and is a configuration file.

Is it the correct one ?, do I have to download it ?

Miguel Altamirano Morales 11-Jan-18 18:41pm

I'm a little confused: Isn´t the GAC a tool for NET environment ?.

That's because we don't have installed any version if VS; at least not in my PC, where I have a testing area with the source database. But in the production area, where test are been doing by the users also, this process (and the dll) are working fine.

Maciej Los 12-Jan-18 0:19am

That's it! Check The latest Version of. Net framework on production area, then download it from MS and install on your workstation. Finally, return to the beginnig of our discussion and repeat all steps to find out what happens. Today i'm on business trip, so i'll be unavailable. Good luck!

Miguel Altamirano Morales 12-Jan-18 17:29pm

Maciej; Have a nice trip.

I even installed Visual Studio 2010, registered the dll in the GAC successfully and I still have the same problem.

Can I keep in touch with you ?. Or is it a matter of posting another question ?

Maciej Los 14-Jan-18 8:34am

Thank you, a trip was peaceful.
Well, you didn't mention about .net framework installation. Have you installed it? It should be exactly the same version which corresponds to working area.

Miguel Altamirano Morales 14-Jan-18 12:16pm

I´m glad you had a nice trip.

The working server has net framework 4.5 installed and my testing PC had net framework 4.7.

I uninstalled the 4.7 versión of my PC and installed the 4.5.

As I expected to find gacutil.exe after doing that, and I did not located it, I downloaded Visual Stuido 2010 ultimate, (I read gacutil.exe comes with this software). The installation process (of VS) told me it couldn´t install the framework 4 because it was already installed, but indeed it downloaded gacutil.exe in 4 different paths (if neccesary I'll tell you tomorrow which one I ran it from).
I ran the gacutil.exe and it sends me a message the library was succesfully registered. I felt very happy for this and thought my problem was solved, but when I tried to test the Access code again, it fails for the same reason ("Can't create the object").
I developed a little VB NET program with the recently downloaded VS and included a reference to two dlls included in the system, but the one with the problem was again not recognized; the other one indeed was. So I just have to guess there is a problem with this dll; but, why it can be running at production level and not in my testing área ?, nor even in VB Net 2010.

Happy sunday !!!

Maciej Los 15-Jan-18 16:14pm

Miguel, seems the only way to resolve your issue is to contact with dll vendor...

Miguel Altamirano Morales 15-Jan-18 16:57pm

My dear Friends of the systems área just told me the productive server they hav is running witn Windows sercer 2008 (after two weeks I'd been asking them to set me up an environment with the same characteristics); so now I´m going to see if it works with this.
I'm not allowed to get in touch with the vendor. (Company´s policies).
Thank you very much, Maciej.

Miguel Altamirano Morales 15-Jan-18 17:59pm

Visual Studio 2017 indeed recognizes this damn dll !!!