Runtime Error 429 Active X component can't create object 1

[gtree]

Hi,

I have created an application with Access and the Backend and Frontend using Access VBA. I am connecting the frontend and the backend using the link tables feature in Access. It was running fine on my earlier machine which had ME and office 97. My new machine has Win XP profession and the same office 97.

When I try to run my program it gives the following error
"RunTime Error:429. Active X component can't create object"

I tried loading MDAC.EXE
I tried loading the MS Soap Toolkit 2.0 and 3.0
I tried loading ssubtmr6.dll

Neither of this worked on my machine.

The program runs fine on another machine with XP professional.

Can someone please guide me what I could be missing here?

Thank you.

 

[RobCPA]

I ran into this same problem with a couple of computers when trying to run VBA code. The problem was corrected by re-registering the DAO350.dll.

The instructions are from Microsoft Knowledge Base article 292054:

http://support.microsoft.com/default.aspx?scid=kb;en-us;292054.

You can get a copy of the DAO350.dll file from a computer where MS Office is working correctly, or you can obtain a copy of DAO350.dll at the following FTP address:

ftp://ftp.microsoft.com/softlib/mslfiles/


To register DAO350.dll, follow these steps:

Click Start, and then click Run.
In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
Click OK


While the instructions on the knowledge base article are longer and more extensive, I simply registered the file which resolved the problem.

 

[gtree]

Hi RobCPA,

Thanks a ton, it worked