jb25
asked on
The database table "xxxx" cannot be found.
I have a Crystal Report that gives me the error 'The database table "xxx" cannot be found. Proceed to remove this table from the report?' when I try to run it for the first time. I click no (there are 2 tables so this happens twice) and then the report runs fine. If I refresh the report again it does not happen but occurs every time if I click on Verify Database from the Database Menu. I am connecting to a MYSQL Database using an OLE DB (ADO) connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Verify on First Refresh was checked in the Report Options. I unchecked it and the report runs fine now. Thanks for your prompt reply.
Re you sure that the report runs ? Check if you are using saved data
ASKER
The report runs correctly. The data is up to date. I'm not sure why but it seems the only problem is that the database won't verify.
Can you refresh the data?
mlmcc
mlmcc
ASKER
Yes, refresh works, verify doesn't.
Is the problem table used in the report?
mlmcc
mlmcc
ASKER
Yes. The report uses 2 tables, both won't verify but will refresh correctly.
If you're accustomed to MS DB's (SQL Server or Access), you likely assume that table names are not case-sensitive. But ... when dealing with MySQL as usually installed on a Linux system ... that assumption is wrong.