Thank you for your answer Vladimir.

My question is: how do you give access to users at a branch office to limited data from tables at headquarters? The user does not have rights to the tables at headquarters through the file system and has to access the data through the program. The tables are free tables, not part of a DBC.

I am very interested in your specialty of math and physics. I studied engineering science which is in the similar direction but much lower than doctoral level. What kind of work do you do?

Alex

>>An application needs read only access to a subset of data from DBF tables in a directory that should be otherwise inaccesible to user. One way may be through another program that does have access to the full data. How can this be accomplished?
>>
>>TIA
>>
>>Alex
>Just rough idea
>Since VFP7 there are events in database
>
>For example,
>dbc_BeforeOpenTable
>If this event return faulse, the table will not be open
>Let we have user table with user id
>We also have othe table with this id and tables available for user
>User permision table
>Wen user log in, we take his ide and put into variable list of tables for him
>Than
>
>

>PROCEDURE dbc_BeforeOpenTable(cTableName)
>*Just before a table or view is opened. Return .F. to prevent table or view being opened.
>IF cTableName$m.usertables
>	RETURN .T.
>else
>return .f.
>endif
>ENDIF
>ENDPROC
>