Thanks for the answer. The reason I didn't wanted the second computer from directly accessing the data is to prevent the entire 1 millon records table from going down the network to select just 1 record.

But I thought that it wouldn't be possible with ODBC - after all, MS sells SQL Server! :-)

>You're right with the exception of the part about the shared directory. In order to set up the DSN on the other computer, you'll have to tell it where the data is. If the data isn't located on a share, the other computer won't see it! This is a problem if you're using VFP data and don't want people having full access to the data via other applications other than your own.

Sylvain