To fix this I just simply selected all fields and the SQL statement was written correctly. Sounds to me like this is a bug that Somebody@Microsoft should fix
>>All,
>>
>> I have an application that will be accessing a remote database. One of the fields has the name "desc". When I create a remote view in VFP 7 and browse the data I recieve the following error message: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'desc'. What work arounds are there for this bug?
>
>what does the select statement for the remote view look like?
>There is also the possibility that since 'desc' is a reserved word it might be causing a problem.
Thanks
Jim