Symptom
Resolution
There is a difference in code between RDC version 9.0 and versions 10 and XI.
RDC version 9.0 uses the following code to change Location in an Access Native report:
Report.Database.Tables(1).SetTableLocation "c\test\new.mdb", "New Table Name", "" Report.Database.Tables(1).Location returns the full path to the .mdb i.e. "C:\Temp\Xtreme.mdb"
RDC versions 10 and XI use the following code to change the tablename:
Report.Database.Tables(1).Location "New Table Name" Report.Database.Tables(1).Location returns the table name. Report.Database.Tables(1).SetTableLocation "c\test\new.mdb", "New Table Name", "" will also change the table name.
The change in the return value of Report.Database.Tables(1).Location may cause a problem upgrading a version 9.0 or earlier Project.
Keywords
RDC report designer component change Location Access Native SetTableLocation , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To