Solved

Crystal Reports 8.5 - Verify Database always says Database file XXX has changed

Posted on 2013-06-25
12
2,379 Views
Last Modified: 2013-06-27
Hi,
I am using CR 8.5 and I have a load of .rpt files.

When I open certain .rpts in CR and do a Verify Database, it always says that "The database file XXX has changed. Proceeding to fix up the report", but only for some of the tables in the report, e.g. one report does this for 3 out of 5 tables used, another for 2 out of 4.  The database is Access 2000 and the structure has not been changed.

This happens every time that I open the report, even if I don't refresh the data.

But some of the .rpts, mainly those created recently, are ok, and Verify Database = "The database is up to date".

Any ideas, please?

Thanks,
Geoff
0
Comment
Question by:lybreeze
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 39277215
Are you saving the report once you have verified the database?
0
 

Author Comment

by:lybreeze
ID: 39277297
Thanks for your reply.

Yes, I always save the report, but next time I open it and do a Verify Database it says that some of the database tables have changed !
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39277353
I don't know what the problem is then.
Is the Access application changing its own table structure as part of its processing?

Why are you running Verify Database anyway?  Are you getting errors in your report?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:lybreeze
ID: 39277443
I wondered if Access is creating a temporary index to make some of the links between tables, but the Visual Linking Expert doesn't show any reason why this should be so.

I started checking Verify Database because certain reports (when run from a VB6 program) are taking up to 1 minute to print, whereas other reports are instant.  This delay is not caused by volume of data. The content of the reports is ok.

It is the reports that are taking a long time to print that have this Verify Database problem, and they do seem to be the older reports, which were possibly originally created using CR version 4.  Maybe there is some incompatibility here?
0
 
LVL 77

Accepted Solution

by:
peter57r earned 400 total points
ID: 39277539
Maybe the origin of the reports is causing problems. I can't say.

Perhaps it might be worth staring a new blank report and using copy and paste to get the essential parts of one of the 'problem' reports into it and seeing what happens.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39277950
Do you see this when you run the reports?

Have you saved them after seeing the VERIFY?

mlmcc
0
 

Author Comment

by:lybreeze
ID: 39278258
mlmcc - no, I only see it when I select it while in design mode in CR8.5
Yes, I always save after each verify.

If I run any of these problem reports either from VB6 or from the compiled .exe when the report has been integrated into the .exe via the RDC then they display/print ok but only after a delay of 30 seconds.

If I externalise them as .rpt files and execute them via the old Crystal Report .ocx control then they display and print immediately.

Following peter57r's suggestion, I knocked up a simple report in CR8.5 using the same 3 tables that cause problems in one of the older reports, and hey presto - everything is ok - Verify Database doesn't keep flagging up that any of the tables have changed..

I guess that indicates that both CR and the database are ok, and that the fault lies in some incompatibility between CR 8.5 and a .rpt built in an earlier version?

Would you agree?

Thanks for your help
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 100 total points
ID: 39278308
OPening the report and saving it should convert it to a CR8.5 report and resolve the database issues.

mlmcc
0
 

Author Comment

by:lybreeze
ID: 39278450
I'm afraid that it doesn't !

I'll close this one now, just assuming that there is a legacy incompatibility in .rpts created in a previous version, and I'll have to rebuild the affected reports in 8.5 !

Thank you both for your help.

Geoff
0
 
LVL 35

Expert Comment

by:James0628
ID: 39280724
This is a longshot, but have you tried using "save as" to save the report under a new name (_after_ you do a "verify database")?  If there is something in the RPT file (an "incompatibility") that's causing a problem, maybe having CR create a new file (using "save as") will leave out that part.

 Just a shot in the dark really, but easy enough to try.

 James
0
 

Author Comment

by:lybreeze
ID: 39280778
Thank you for your suggestion James, especially after I had closed off the question  :-)

However, I tried doing a Save As but unfortunately it didn't make any difference.

Regards,
Geoff
0
 
LVL 35

Expert Comment

by:James0628
ID: 39280954
Oh well. It was worth a shot.  :-)

 James
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports last day of month 2 68
Crystal report highlighting 5 53
Null as value for Dynamic parameter in CR2008? 9 58
Analyze Shared Variable? 7 27
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question