Change report table name

[ideasworking]

Hello,

I am using CR8 developer and VB6. The report in question is in an Access database connected through ODBC. Right now the report is looking at a table that I want to rename. When I rename the table I loose fields on the report. Is there a way I can quickly change all report fields to reference the new table name?

TIA

 

[jdemmi]

If I am understanding you correctly....you're renaming the table on the DB (Access) side.

I THINK that if you:

1. Open the report in the designer
2. From the Database menu choose SET LOCATION
3. Note which table is highlighted (example Table_1)
4. Press the SET LOCATION button
5. Login in DB if required
6. Select the "new table" which corresponds to the table in step 3. (TABLE1)
7. If asked to propagate server and DB changes across... select Yes.
8. When you close out of the set location menu the DB will be verified and you will be asked if you want to "fix up" the report. Click yes.

That should take care of it.....

 

[dgillz]

Jdemmi is right on but there will still be one problem, the table will still be named what it originally was when you forst wrote the report.

To fix this, click on database, set alias, and rename your table to the new table name in MS Access. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com