>I only have one slight problem preventing that. I already have a client who has designed several reports for this application and all of the reports are based on VFP5.0. I suppose I can look to see how easy it will be to convert the database type. Thank you for the suggestion.
I'm not sure you understood the answer. Keep the data in VFP tables, using the DBC, etc. When you run the report, use a PRG to extract just the data needed for the report, then COPY TO Temp.DBF TYPE FOX2X. Have the CR use Temp.Dbf. Doing it this way provides a couple of advantages. 1) It will use Rushmore to pull the data. 2) You don't need ODBC to access the data, which not only simplifies installation and support, but will also be faster.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer