hi there!

I'm using CR 9 with VB 6 and MS-Access-XP. In my app, I use the CRAXDRT.Application obj to open a CR9 report designed using Field Definition File(s) & get its reference into a CRAXDRT.Report obj. I then pass the Report object parameters and ADODB.Recordset objects. Finally I set the ReportSource property of the Crystal Reports Viewer 9 control to the Report object, call its ViewReport method and voila! Everything works fine.

What bugs the app is that when a user opens, closes and reopens the report (after changing report criteria) more than 70 or perhaps 80 times, a runtime error occurs. The error no. returnde is -2147467259 and it says "Cannot open anymore tables".

Plz help.

Your help is greatly appreciated.

ejan

__________________
ejan