After server migration, some reports fail with File Not Found error

[nowickil]

My client uses Crystal reports 6.0. It is installed on only one Windows '98 network attached PC. The report definitions are stored on a server. (Novell Netware network.) The reports pull data from an Access Database which contains 35 tables. This database is also stored on a network server. The customer's IT department came in and did a server migration. After the migration, most of the reports print normally. However, reports that try to access data in the "promo/cust" table or the "sites" table in their Access database fail. Reports accessing any other tables in the same DB work just fine.

The actual error message is:

Seagate Crystal Reports
Database Error
Error Opening File
File could not be opened: "sites". Please check its location.

This repeats for file "promo/cust".

Then we get a message "file not found".

The customer is not using compiled reports.

Users who access the database using the Microsoft Access front end forms, queries, and reports have no trouble accessing the Sites or the Promo/Cust tables, so it appears that Access knows where these table are. Crystal Reports knows where 33 of the 35 tables in that database are - it just can't find two of them. Does Crystal Reports have it's own index into the Access Database that could be corrupt and in need of repair? If so, how does one do this? I've never actually used Crystal reports, I was just brought in on this because their IT department gave up.

Any thoughts?

Thanks in advance,

nowickil

 

[SurfingGecko]

Are these reports ODBC or natively connecting to the Access source.

If ODBC, make sure the DSN(s) have been configured properly and are System DSN's

If native make sure the original path to the file is the same as it was prior to the change.

Depending on the number of reports you have, you may want to open them up and do a 'Verify Database' to reinistialize the indexing.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[nowickil]

Thanks for the tip. I believe the reports are natively accessing the Access source.

Please remeber I'm totally new to Crystal reports. I appreciate your patience with what must be newbie kinds of questions. Where/how do I check to make sure the path to the file is correct?

I will take your advice and open the reports and do the 'Verify Database' to reinistialize the indexing. I can't try this until I'm back at the client site later this week. I don't have Crystal here. Can you describe for me how to find this option? (I'd like to at least look like I sort of know what I'm doing when I get there... Thanks in advance for all of your help.

PS - sorry for the late follow-up, I got called out of town and couldn't check this.

 

[SurfingGecko]

no question is dumb if you do not know the answer...

When you open the report in the designer navigate the menu to Database > Verify Database

When you click this the designer should perform a database check and alert you whether or not the report is "up-to-date" or requires fixing...

You may also see an error when opening the report (if it does nto have saved data) if the connection can not be made. In this case, you may need to go to Database > Set Location to repoint this report to the Access source .mdb file. This would reqrite the connection info in the .rpt file itself.

Depending on the OS, you may also want to ask what version of MDAC is installed. The issue could be related to the MS DAO version on the machine.

Also check to ensure the client machine has a copy of p2bdao.dll, p2ctdao.dll, p2irdao.dll. These are the CR Access drivers. They should be in the system folder.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[nowickil]

Thanks,
I am scheduled to be at the client site this Friday, 6/27, and will let you know how it goes.
Take care.