CR 9 SetDataSource Causing RunTime Error

[jjwild]

I have recently installed CR 9 to replace CR8 in the project I am working on. I am using VB6 and opening the report from a VB form.

With one report, the first time it is run causes a run time error on the line of code with the Database.SetDataSource. The error is:
run time error ’75
“Path/File access error: 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VB111.tmp'”

This only happens the first time the report is run after the project has been started. If I move through the error using the debugger, the report runs correctly. If I close the report and rerun it, the error does not occur.

There are many other similar reports in the project, none of them have this problem.

This report is run from the Form_Activate routine of the VB form. If I move the running of the report to an event that is triggered after the form is loaded and activated, the error does not occur.

Solutions?

Thanks,

John Wildanger

 

[GJParker]

Don't know if this will make any difference but, you could try using DoEvents before setting your datasource ?

HTH

Gary Parker
Systems Support Analyst
Manchester, England