Setup:Crystal Report 8.5, vb6, ado 2.7, xp, access table

A distributed report to a client get the error:
"file could not be found: "PromoKey" at location: "PromoKey".

    rs.Open sSQL, cn, adOpenKeyset, adLockOptimistic, adCmdText
    Screen.MousePointer = vbHourglass

      Report.Database.SetDataSource rs, 3, 1
     CRViewer1.EnableExportButton = True
     CRViewer1.EnableRefreshButton = True
     Report.ReportTitle = "Report from " & FromDate & " to " & ToDate

    CRViewer1.ReportSource = Report
    CRViewer1.ViewReport

The access table name is PromoKey.
I seems Crystal wants the file in the same location or is trying to used
saved information.  If I'm passing it the recordset, does Set Location or ?
still have to be made?

Len Latimer