ActiveX cant create object 1

[JackD4ME]

Hi All,
I am using access97 and have some code that uses the call and shell statements. The code works on the dev. machine(I did have to change from MS dao3.6 to 3.51 for the target). The code is below.

MsgBox "Got Here"
Call Shell("path\program.exe", vbNormalFocus)

I know it reached this code because of the preceding line. The error I get is "ActiveX cant create object." Is there some reference that I am missing? Or a library registry setting that was not installed on the target? I am very confused?

Thanks,
Jack D

 

[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.

 

[glrpfi]

a global way to resolve many of these issues is to ensure MDAC 2.6, service pack 1 is installed on the machine. Among its many bugfixes and issue resolutions are bad reference issues with active x.