Solved

Error 429 ActiveX component can't create object

Posted on 1998-06-08
7
619 Views
Last Modified: 2008-02-01
I don't know what the hell happened with my ACCESS.
Any call I make to a DAO object or declaration (set db=Dbengine (0)(0) for eg.) is causing an Error 429: 'ActiveX component can't create object or return reference to this object '
I've removed and reinstalled my ACCEESS several times, as well as any DAO key I found in the Win NT registry.
And even following the Microsoft procedure for this bug (Q185126) the problem persist.
How can I fix it???
0
Comment
Question by:ssa060398
7 Comments
 
LVL 12

Expert Comment

by:Trygve
ID: 1975014
Try opening a module and make a full compilation. If you choose Tools, references (might be chosen by the compilation procedure) you will probably find that one of the controls is either missing or of another version than the one one you used when you made the mdb. Yes, I know it is not for everyone to go around knowing which version that are installed, but give it a try. Missing refered control will be marked (yes, you guessed it Missing...)

Hope this helps !
Trygve
0
 

Author Comment

by:ssa060398
ID: 1975015
There are no missing references.
I've got this error message in my first DAO call (set db=dbengine()()).
I think is a problem in DAO registration. But I've no clue.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1975016
I found that the DAO reference was poiting to the wrong directory when I once installed Access on a WinNT machine. The trick was to Tools, references and point the DAO reference to the correct location. Also check that you have Visual Basic For Applications (...MSAPPS\VBA\VBA332.DLL) and Microsoft Access 8.0 Object Library (...Office\MSAcc8.OLB) on the list.

Last check that the Msrdo20.dll file is installed in the WinNT\system32 directory and properly registered.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Accepted Solution

by:
pglick earned 50 total points
ID: 1975017
I recently came across a solution to a similar problem.  To see the full solution visit http://home.att.net/~dashish/ then choose "bugs" and you will see a reference to Error 429.

The solution involves running the program Regsvr32.  I believe that the file you want to register is DAO350.dll.  You need to give Regsvr32 the full path of this file.  Before doing this, you should verify that this program works on WinNT

0
 

Author Comment

by:ssa060398
ID: 1975018
Now I have my ACCESS back !!!!
Thanx!
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1975019
Could you tell us what did the trick ?
0
 

Expert Comment

by:bssi
ID: 1975020
One area to look at particularly if you using office and VB is whether you are using the default drive and directory.  You may have to reinstall into the default microsoft directories to allow proper coordination.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

911 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