Solved

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

Posted on 2013-06-25
12
2,311 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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 34

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 34

Expert Comment

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

 James
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now