Linking Access DB to ODBC in Crystal

[starflt1701]

There is probably a simple solution, but I can't find it. I have linked an Access table to ODBC tables in an existing report. I am using the Access table to feed parameters to the Crystal report. When I did so, a dialogue box told me to go into report options to convert which database drivers were being used. When I went into the Report Options, I couldn't see where to do this. So I closed this and ran the report. Seemed to work OK. However, since then, I have added additional tables from the ODBC database. They seem to link OK, but when I execute the report, I get no data from the database fields from the newly added ODBC tables. Please tell me what I am missing.

Thanks,

 

[synapsevampire]

Consider a slight redesign.

Instead of linking within Crystal, link (not import) the ODBC tables into Access, create a query within Access which handles the joins, and use that Query within the report.

-k

 

[starflt1701]

Actually, that was my first choice, and I have done that with other, more complex reports. However, the identical tables linked into Access, and the query constructed the same way as the Crystal Report, ran like a dog. Slow as molasses. Actually ran more that 10 times faster in Crystal. I tried everything I could think of to make my queries more efficient, including writing sub-queries to be joined at the master query with no improvement in result. That's why I decided to go the Crystal route. Any ideas?