>Thanks.
>I have another problem; i try to explain it:
>1) I have my server with SQL server installed;
>2) in SQL server i have created the linked server, but foxpro tables aren't on the same server of SQL but on anotherone. I have put in datasrc the full path to point to data (for example \\server1\vfp\data);
>3) when i execute a query or open one view in SQL i receive an error message;
>4) if i put my fox tables in a local folder of my server where SQL i installed i have no problems.
>Where is the error ? There is a particular user i have to use or define on the "remote" server ? I have seen that in the properties tab of the linked server there are info about "Protection" but i inserted a user and its password to access but nothing changes.
>
>Thanks

Foxpro is a file based system. For it to work you need at least read rights to the folder where the data is on that remote computer. IOW from the computer where you have SQL server the current logon should be able to access the folder on remote.
I wouldn't use linked server to VFP when the data is on a remote computer. If you need to install something like SQL express on that machine, that instance accesses VFP and you access that SQL instance remotely.
Cetin