Oh yeah, its been awhile. I forgot it can't use a 4 part name. Thanks, the ODBC version works now. The OLEDB one still gives an access error, but it works with ODBC, so thats fine.

>>The servers are getting set up, but I am still having problems accessing them.
>>When I try the OLEDB setup like this:
>>

SELECT * FROM test...temptbl

>>I get this:
>>OLE DB provider 'VFPOLEDB.1' reported an error. Access denied.
>
>The account Sql Server runs under doesnt have access to the free tables directory.
>
>>When I try the ODBC driver like this:
>>

SELECT * FROM test1...temptbl

>>I get this:
>>Invalid schema or catalog specified for provider 'MSDASQL'.
>
>You have to use OPENQUERY().

SELECT * FROM
>	OPENQUERY(test1, 'Select * From mytable')
>

>>
>>What am I missing?
>
>Make sure that account that Sql Server runs under has access to the free table directories. It's also beter to use UNC path because it doesn't requered mapping.
>< snip >