I have this really weird issue going on. I am using an old version of Crystal Reports. The version that I am using is 4.6.1.0. I am using VB 6 and SQL Server Express.

I have created several reports that use several database fields. Evertyhing is working fine. I have created another report that uses some database fields. The new report also uses one database field (firm name) that I use in the other reports as well but for some reason the new report crashes when I use this field. I have removed this field (firm name) from the new report and it works fine, but when I add this database field it crashes for some reason. I can't figure out why the new report crashes, while the old one which uses the same field works fine.

Here is the code that I use.

Dim report2 As CrystalReport
report2.Connect = "DSN=SQL Server Remote Location;UID=ikim;PWD=red;DBQ=<CRWDC>Database=CopyRequest"
report2.ReportFileName = sPrintLocation & "\printing2.rpt"
report2.SelectionFormula = "{CopyRecords.unique_id} =" & scurrenlyOpenRecord

report2.PrintReport