dtempleton
MIS
Using Crytstal Rerports 8.5 and Access 2000.
I'm trying to create a Crystal report with my current Access Database. I can add a table to the report with the code below. After that, though, I cannot close Access. The database seems to close, but the Access window itself will not go away no matter how many times I manually try to close it.
The problem seems to be coming from the "CrRpt.Database.Tables.Add" line. Any clue what I'm doing wrong? Is there another way to add that table?
I'm trying to create a Crystal report with my current Access Database. I can add a table to the report with the code below. After that, though, I cannot close Access. The database seems to close, but the Access window itself will not go away no matter how many times I manually try to close it.
Code:
Dim CrRpt As CRAXDDRT.Report
Set CrRpt = New CRAXDDRT.Report
.
.
CrRpt.Database.Tables.Add CurrentDb.name, "MYTABLE_1"
.
.
CrRpt.SaveAs "C:\MYREPORT_1.rpt", cr80FileFormat
Set CrRpt = Nothing
The problem seems to be coming from the "CrRpt.Database.Tables.Add" line. Any clue what I'm doing wrong? Is there another way to add that table?