>We have problem creating our forms based on back-end datasource.
>Our setup...
> Back-end : SQL Server 6.5, Contains table(s) and view(s).
>Front-end : Visual Foxpro 5.0, Contains Remote View(s) based on SQL
>
> At SQL end users have access to tables/views and some of users have access
>to some specific fields only whereas the forms are accessible to all users.
>We have noticed that if user does not have permission to any one of the fields
>SQL returns an error.
>
>How can we dynamically modify our view at run time, depending on what fields
>user can see, without changing the original view.

I guess you should use different view definitions (try to do it programmatically using e.g. CURSORSETPROP()) for different users depending on their security status (could be implemented as individual/group user accounts for VFP app).