Hi Hank

Good to hear from you.
Thanks for your ideas. Yes, good tip to register as Administrator. Will do.

As regards the data: I am creating tables in the users temp folder. Then I am substituting the table name in the Crystal report with the temp table, via:
_Screen.oCrystal.changetablename()

Has worked forever. I wonder if something in Windows has changed to affect it.

The idea that Lutz gave me - to reset Crystal completely before each report - is looking promising.

Regards
Cyril





>Hi Cyril,
>
>Assuming you are reading VFP tables, are they on the same server? Think: permissions to access.
>
>On modern systems, the CR9 dll's need to be registered as Administrator.
>
>From an administrative CMD (or Administrative PowerShell, issue CMD once in):
>
>c:\windows\syswow64\regsvr32 "C:\Program Files (x86)\Business Objects\Common\3.5\bin\craxdrt.dll" /s
>c:\windows\syswow64\regsvr32 "C:\Program Files (x86)\Business Objects\Common\3.5\bin\crqe.dll" /s
>c:\windows\syswow64\regsvr32 "C:\Program Files (x86)\Business Objects\Common\3.5\crystalreportviewers115\ActiveXControls\crviewer.dll" /s
>
>Remove the /s if you want to get a messagebox with result for each command.
>
>Hank
>
>
>
>>>>My program has been running successfully for many years.
>>>>
>>>>All of a sudden we are seeing the C5 error on this line:
>>>>This.crReport.ReadRecords()
>>>>
>>>>The first time the report is run, it is OK. The next time, it gives the C5 error.
>>>>
>>>>I use Crystal reports 9.
>>>>
>>>>If I exit my program and start again, the report runs fine again the first time. The next report gives the C5 error.
>>>>
>>>>Any suggestions on what to try?
>>>>
>>>>Cyril
>>>
>>>Have you tried to release This.crReport after first run? Also closing / removing Crystal with all you see you can remove? IOW Crystal Clear. :)
>>
>>Hi Lutz
>>Good idea - that gives me something to try.
>>
>>I wonder if there is something in the latest Windows 11 update that caused this!
>>
>>Thanks
>>Cyril