VB6 & craxdrt.dll: verify report database in code

[timmah13]

I have 100+ reports which were created using a native connection (psbdao.dll) to an Access2000 DB in Crystal Reports 8.5. In VB using the craxdrt.dll, I'd like to automate a way to verify each report against the DB. I am able to view a report at run-time if the DB has not changed, but I get no data showing if the structure has changed. I realize that I could open the report in CR85 and Database|Verify then save it, but that's quite time consuming for so many reports. Has anyone had success in verifying a report through VB? If so, is there an easier way to save the verified report other than calling the SaveAs method of the report object and then renaming to the original filename?

Thanks for any and all help...

 

[JoeCrystal]

You can use:

rpt.database.verify

Where;

rpt is Crystal Report Object

 

[timmah13]

Believe me, I've tried using the Verify method. I seem to get it to work if I first convert the DB driver to ODBC, but that does no good since the networked computers don't have any DSNs pointing the the DB. I'm trying to find out if there is any way to verify a report if it was designed using a native driver. Keep in mind that calling the method and having it actually work are two separate issues!

 

[JoeCrystal]

I should of mentioned that you should logon to database before you verify. I recall that I had the same problem until I remember that if you open up a report and verify it will want you to log on first. Where I used it was an application using the Lotus Notes native driver and it work as soon as I place the database logon code before the call to the verify method. Before that it would except the call but not verify.