Thanks Sergey

These are views I have created using the DBC designer, using create new view. They were not created in code.
It turned out that I did not have the right setting in the Data Source.

After I set trusted connection to true in the data source settings from control panel all was well:)



>Add Trusted_Connection=Yes to the connection string.
>
>>I have installed MSDE from the VFP7 CD and can succesfully connect to it using remote views from the VFP DBC Designer.
>>
>>When browsing these views from the DBC designer a dialog box keeps poping up and I have to tick the box for
>>
>>Use Trusted connection
>>
>>How can I force trusted connection to be the default.
>>
>>Previous theads in UT say to use the enterprise manager but I cant find this and suspect it is only part of the full blown SQL Server package.
>>
>>Many Thanks