VBA Code Not Working In Run-Time Env

[JackD4ME]

Hi All,
I have some code installed on a form. I have MSDAO3.51, VBA, and MS Access 8.0 Lib for references, very basic. I defined a db, recordset, and string: db, rst and st respectively. My target machines are using MS Access 97 RUN-TIME. The code happens to be in the form_load event and gives the "Run-Time Error '429' ActiveX component can't create object."
By commenting out the rest of the code in the load event proved it was these DIM statements bombing the program. I have searched the Access help to no avail on what would cause this. Does anyone know why this might be happening?

Jack D.
"The best minds are not in government. If any were, business would steal them away."
-Ronald Reagan

 

[GKProgrammer]

Hi Jack,

Have you verified that these target computers have these library files on them as well? If not you will have to add them to those computers.

Regards,
gkprogrammer

 

[JackD4ME]

I have all 3 of the references on the target station, however they are in different dirs. Is this going to make a difference or are they mapped when run-time is installed?

Jack D.

 

[GKProgrammer]

This will make a difference but the only way to be completely sure is by trying to run your runtime version of your DB on the computer that it was designed on. If it works fine on this computer than that is your problem. Regards,
gkprogrammer

 

[JackD4ME]

I removed Office Pro and run-time from my dev machine and installed run-time on it-program bombed out. Reinstalled Office Pro and program stills bombs out. DAO3.51 was missing. Located it and set the reference but it still bombs out! On a whim I installed DAO3.6 and it works. Decided the best course of action was to install a copy of 3.6 at all customer sites in same dir as program. Thanks for the advice.

Jack D.