Solved

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

Posted on 2013-06-25
12
2,448 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

 

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 101

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 101

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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

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. …
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 are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

636 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