CR 8.5 not "seeing" some foxpro tables

[kab555]

I've been struggling with this one for months. For some reason, Crystal is not seeing several foxpro tables. It does not matter if I use an ODBC connection or a native drive connection, the results are identical. This problem also has nothing to do with the length of the table names, as Crystal is able to see some tables that have in excess of 10 charaters in the table name. Also none of the foxpro tables are locked.

Anyone have the same problems?

Thanks!
Kristie

 

[AndrewBaines]

I've never had this problem, but try:
File|Options
Database Tab
Show - select all the boxes Andrew Baines
Chase International

http://www.chase-international.com

 

[DerekMcDonald]

I'm experiencing exactly this problem. Did you ever solve this, Kristie?

Thanks!

 

[kab555]

I've never solved this one. I have a hunch that the tables that I could not see may have memo field in them. My workaround was to export the data from the foxpro tables and import them into Access (yucky), but you can have the import/export process automated, so that you only need to go through the pain just once.