Thanks. I tried it, but I keep getting the error that the DBF file does not exist from the ODBC driver. I'm connected through a network to the data through Novell. I set up a DSN to the data directory and I could see the contents of that directory fine. Any ideas why this might be? Are/Have you used this method?

Phillip Perkins

>>Does anybody know or have an example of a routine in which I can link SQL tables to free FP tables? I think I've heard of this in SQL talk somewhere, but I can't remember where.
>
>HOWTO: Do SQL Server 7.0 Distributed Queries With FoxPro .dbf Files
>
>Q207595