Crystal Reports 4.5 - Verify database is not seeing new fields?

[bradair]

I'm using CR version 4.5 which came with VB6. I have added a new field to my MS Access 97 database and when I try to verify the database in CR, I do not get the "Database is up to date message", and the field does not appear. I've tried renaming the database and also moving it to another location to try to trigger the "Verify database" function to work.
Any ideas anyone?

 

[BurrardView]

Hi;

Try going to the Set Location window, and re-pointing the report to the database.
If that fails, you may have to re-create the report. That version had some problems with case-sensitivity in the database. Later versions have the option to change the table name, which usually solves the problem. (See Crystal Decisions kbase c1414811

Best Regards,
Jonathan

 

[bradair]

Hi Jonathan

Thanks for the info but I had problems finding
Crystal Decisions kbase c1414811
Their kbase site does not have this reference.

Could you be kind enough to check if this is the correct reference. In the meantime I'm recreating all my reports.

Thanks
Brian

 

[BurrardView]

Hi;

Sorry, must have been an older doc. Here it is:

Verify Database doesn't pick up changes in Structure
Product: PR~ Version: 4.50 5.00
Database: ACCESS~ Platform: WIN3
Type: TIP~ Status: GOOD
Problem:
The structure of a given table is changed on a regular basis, with new fields added to the table structure through code.

Selecting Verify Database, however, results in no messages being returned. The message expected is one denoting a change in database structure and a subsequent prompt producing an option to fix up the report.This report was created with CRW 4.5 and it works in CRW 4.5 & 5.0 16-bit However for both versions, CRW 4.5 and 5.0, 32- bit fails to recognize changes made to the table.

Analysis:
The problem is the alphabetic case for the table name. The table name is: PhysData.The table specified in the report was PHYSDATA.

Solution:
Open the report in CRW 32- Bit. Select Database|Set Location. The bottom of the window should display, File: PHYSDATA!c:\test\test.mdb. Change this to PhysData!c:\test\test.mdb.

Select Done. Now select Database|Verify Database. You will now get the message "Database has changed do you want to proceed to fix up?"

However having the Verify on Every Print checked doesn't get read at runtime for CRW to notice that there's a change in the database. Track #4576 & 4575.

JAF
96-10-16
c1414811
KBASEID: c1414811

KBASEID: c1414811

Jonathan

Best Regards,
Jonathan