Hello everybody,
I have the old working report written in Crystal Report 9.0, which is using queries from Access 97 database. Now I have to do some changes to this report. I've created couple new queries for those changes and tried to replace the old query to new one using the Database Expert in Crystal 9.0, but I do not see those new queries in the list of all queries in my database. I am using ODBC connection from the Crystal Report to the data source. I've created that report by myself a year ago on same PC. But after that I've installed VS.NET on my PC. I had a guess about some conflicts, but I've uninstalled VS.NET and Crystal Reports 9.0 and installed Crystal again but it did not help. I've opened the new report and connected to same DSN to see those queries, but I cannot see them again. What is going on?
I am in frustration. I really need your help.
Thanks on advance.
-Dmitriy
Access queries and Crystal Report 9.0
!!!) in the list of [u]views</u>. I've checked the MS Access system tables and found my new queries in the MSysObjects table but did not find them in the MSysQueries table. Maybe because of this the Crystal Report does not see them as queries. But here I still do not understand the reason the Access is treating differently almost same queries (I've just copied the existing query and renamed them)?