If you are trying to access VFP tables with ADO, make sure the SYSTEM account on the Box you are running the ADO (web server?) has full access to the directory on the server where the VFP data resides.

BOb


>>>Hi Bob
>>>
>>>I am trying to make a remote view on the SQL Server.
>>>
>>>Can I make such a view against a FoxPro table?
>>>
>>>
>>>Kenneth
>>
>>So, you are trying to make an SQL Server View (not called a remote view which is confusing me.)
>>
>>If that is what you are trying to do, yes, you can create a linked server to the FoxPro table, then create a view that looks at the linked vfp table.
>>
>>BOb
>
>Can the vfp table be on a different box?
>The problem I have, I can't get ado to work if my web server and vfp tables are on different boxes. I could have SQL Server and vfp tables on the same box and link my web server to the SQL Server. This is the long way round but all the data is still in vfp tables and my vfp app updates vfp tables.
>
>Thanks Anthony