Crystal Report 8.5 - error getting data from Query in Ms Access 2000

[got01ar]

Hello: I am creating a Crystal Report 8.5 getting data from a query in Ms Access 2000 and the following error appear when I try to choose the row from Crystal:

- There are no fields in the file .......

I can access without the same query without any problem from Ms Access

 

[synapsevampire]

Perhaps it's a connectivity problem, or perhaps the Query isn't returning anything.

If you change the connectivity to ODBC or Direct, does that help?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[got01ar]

The problem is that the Query in Ms Access has a Visual Basic Function. Do you know if it is possible call via ODBC a MS Access Query that has Functions associated ?

- I had the same problem calling the Query from Excel.

Thanks