INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

CR-V5 - Verify Database - File could not be found

CR-V5 - Verify Database - File could not be found

(OP)
We are using CR V5 (yes its OLD, but we have a lot of CR Reports already written and they are not automatically supported in later versions).

Regardless, when I open an existing CR V5 report and then try to do a Verify Database I get an error message indicating:
Error Opening File - File could not be found.....

The Data Table is a Visual Foxpro 'free' table.
CR is on a workstation and that Data Table resides on the server and is accessible via a mapped drive.
The Data Table will self-launch into Visual Foxpro when I navigate to it and double click on its filename.

Everything I test with indicates that the Data Table is fully accessible to the workstation

Just for testing purposes I have attempted to do the same test with multiple CR V5 Reports (each using different Data Tables - same mapped server, but in different directories) and get the same result each time.

I am no CR expert, but it seems as though something is configured wrong with this CR installation.

What can I do to correct the problem?

Your advice/suggestions would be greatly appreciated.

Thanks,
JRB-Bldr



RE: CR-V5 - Verify Database - File could not be found

I mostly work with Crystal reports with data in Access, but I would try to create a new connection to the data.

RE: CR-V5 - Verify Database - File could not be found

(OP)
Thanks for the reply.

I did finally resolve the problem, but it did not occur as I would have liked.

I ended up having to do it the PULL TEETH manner by Removing all of the "Free" Data Tables from the Report - thereby causing all fields to disappear.

Then I Added the single primary table back in.
Finally by using the Visual Linking Expert I was able to add back in the 2nd 'Free' table.
NOTE - when I tried to add in the 2nd table using the Add Database to Report it did NOT work. It continued to assume that the new data table (a.k.a. mistakenly called a Database) was an Access component and was requiring me to log into that.

At this point I was able to successfully execute a Verify Database

Now I need to go through and recreate all of my Report Fields.

Regardless, thanks for the reply.
JRB-Bldr


RE: CR-V5 - Verify Database - File could not be found

I've run into that issue before with an application that had built in security and you needed to grant access to each table.

RE: CR-V5 - Verify Database - File could not be found

(OP)
Charliy - I appreciate your reply. In this situation that was not the case.
This was a previously working CR Report and it was already successfully accessing the same data tables.

The reason this was encountered was that one of the tables had new fields added and the existing report now needed to be modified to utilize some of those fields
Unfortunately the Report refused to show those new fields from the table as available.
To resolve that I attempted to do a Verify Database and then Fix the report.
That did not work.

Thanks
JRB-Bldr

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close