>Hi All!
>
>I tried creating a remote view of a SQL Table (SQL Server 7)- nothing fancy, selected all fields and closed it. Browse works fine. Tried modifying the view -- I got the error message box that says "Syntax Error".
>
>I have SQL 2000 Client installed on my workstation. I am using VFP 8.0 SP1.
>
>Any help regarding this error is greatly appreciated. TIA.
>
>Robert Lee

Are you sure the connection is ok. How did you create the view?