I am working with a VB6 app, and it uses Crystal Reports 8.5. It used to work when I had unbound fields on the reports, but my boss said we need to use bound data fields.
So I changed the reports to use bound data, but only some of the reports now work. The data being passed to the reports is in the form of a recordset. I have a check in place to make sure there are records to post, and for some reports, it acts as though no data was passed at all.
On some reports I get an error "Unable to access first record." Then it tells me "SQL Server Error." But I am using MS Access as the datasource, and I have checked to make sure that all the fields in the database have not changed in any way to what was used in design time.
Any help would be greatly appreciated.