CreateObject error "The system cannot find the file specified."

[sharkatek]

Hello,

I have an application in Access 2000 that automates the execution of a Cognos Impromptu query. The version of Impromptu is 7.1

Here is the code to the point where the error occurs:

Dim objImpApp As Object
Dim objImpRep As Object
Dim strReport As String
Dim strCatalog As String
Dim strReportImrName As String

strReport = Me.lstReport.Column(3, 4)
strCatalog = Me.lstReport.Column(5, 4)
strReportImrName = Me.lstReport.Column(8, 4)

Set objImpApp = CreateObject("Impromptu.Application")

The CreateObject command gets this error:

Run-time error '-2147024894 (80070002)':
Automation error
The system cannot find the file specified.

I have read through all existing threads looking for an answer to this but have not found any. I have tried a couple of things already. I did change the code to use "Impromptu.Application" instead of "CognosImpromptu.Application" This made no difference.
Also, I checked the impromptu.ini file and changed the temp file to C:\Temp and this made no difference.

The user who is getting the error has MS Access 2003 loaded on her machine and all references in the Access VB code match mine except for one (it runs on my machine with my ID but I have Access 2000). The only different reference is:

mine (Access 2000) Microsoft Access 9.0 Object Library
hers (Access 2003) Microsoft Access 11.0 Object Library

Can anyone give me any suggestions to help get my code to run?

Thank-you!
Sharkatek

 

[griffindm]

The call CreateObject("Impromptu.Application") has been replace with the call
CreateObject("Cognos.Impromptu.Application").

Alternately, you can call a specific version by adding .cerx to the end (where x is the cer version number (1-4)).

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[sharkatek]

Hi Dave,

thank-you for this suggestion. I tried it and now on both my machine and the user's, we get:


Run-time error '429';
ActiveX component can't create object


any new suggestions? I do not know how to specify the .cer version - I do not know what that is.

Diane

 

[griffindm]

Is this error being thrown at the same line?



The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[sharkatek]

Yes, the same line.

 

[griffindm]

Can her machine run an impromptu report by double-clicking on the report in Windows Explorer? It sounds like you have a registry problem with Impromptu on her computer.

I would do a registry search for the string "CognosImpromptu.Application" to verify that her computer sees this as the alias to launch the Impromptu application.

I don't see how the difference with the Access Object libraries should be causing this error that would prevent Impromptu from even launching at all.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[christenhusz]

i agree with griffindm.

you can also try filemon and regmon. You can download these small tools free from the internet. (use google for example). These tools will log which files and registry keys are accessed. When you find in the (BIG!) logfile access denied then you know where to look..

hope this helps

christenhusz