We help IT Professionals succeed at work.

Error 429 ActiveX component can't create object

ssa060398
ssa060398 asked
on
Medium Priority
733 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???
Comment
Watch Question

Commented:
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

Author

Commented:
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.

Commented:
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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Now I have my ACCESS back !!!!
Thanx!

Commented:
Could you tell us what did the trick ?

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.