>>>Form that is accessible to users with different security Rights.
>>>How to control field level security on your forms?
>>I would say, create a function that check for access rights in the object's WHEN method. Perhaps something like...
>>
>>FUNCTION CHK_ACCESS
>>PARAMETERS table_field
>>RETURN(SEEK(login_id+table_field,'SECURITY',login_field) and SECURITY.ACCESS)
>>
>>where you have a table called SECURITY that has fields for login_id, table_field (i.e. "anytable.fieldname"), and access (.t. or .f.) indexed on login_id+table_field TAG login_field
>>
>>In your WHEN method
>>RETURN(CHK_ACCESS(THIS.datasource))
>
>I am using SQL 6.5 as backend and VFP 5.0 as frontend.
>If A user does not have a select right on one of the fields, an error will ocur when trying to open the remote view.
I am not familiar with SQL 6.5. I assume that the field level rights are assigned from the SQL backend. Is it able to set read-only field level access?