Link to home
Start Free TrialLog in
Avatar of ssa060398
ssa060398

asked on

Error 429 ActiveX component can't create object

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???
Avatar of Trygve
Trygve

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
Avatar of ssa060398

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of pglick
pglick

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Now I have my ACCESS back !!!!
Thanx!
Could you tell us what did the trick ?
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.