Clay,

Sorry, for responding so slowly. I just noticed this in with my replies and I don't think I ever replied back to your question. We ended up doing basically the same thing. Pretty far removed from this project now, but as I recall we did basically the same thing. We pull down all the data from the remote source each morning at the beginning of the work shift and put it in local VFP tables.

-Don

>>The back end is some proprietary database. It's basically an unknown since we know almost nothing about it and have very little documentation on it. The database is for a product called Global Shop. They claim it is some sort of COBOL database?
>>
>
>Hi Don,
>
>Is the back end proprietary database DB/C by any chance, using the FS3 ODBC driver? I ask because we're currently working on a project with this dinosaur back end (sequential index reads, flat files, Databus language)...uggh. :)
>
>Did you come up with any performance tips regarding your queries? We've decided to just pull down the tables locally each night and then run our queries. Even so, pulling down the data can take quite a while for the eight or so tables we need.
>
>Thanks,
>Clay