Hi Frank, thanks for your reply.

User-rights ??

I was'nt aware that this was available in VFP tables, How do I set up rights ? (Also will other applications respect these rights e.g. If a user has an app written in Access and he tries to access the VFP tables thtough ODBC or OLEDB)


Regards,

Gerard


>How about user-Rights on the table?
>
>Or did You play with the Database-Events, could probably do the trick
>
>>Hi.
>>I have an APP using VFP DBC's and another deveoper using Access ,needs to gain access to the the VFP files.
>>
>>I am concerend about security, and Ideally would like to give the developer 'Read Only' access.
>>
>>Theres a number of ways this can be done:
>>
>>1. Copy out the files to say XML or CSV and let them be accessed from there
>> (However, then any changes made to the VFP data is missing)
>>
>>2. Let the Access Deveoper 'Access' the VFP files through ODBC or OLEDB
>> (But then he presumably has full access and can start amending /deleting data.. I dont want thios to happen)
>>
>>3. Is there another way ???
>> Can I control access in some way by creating a DLL which Access can use
>> Can 'Read Only' ODBC link be set up ?
>>
>>Any suggestions welcome
>>
>>Regards,
>>
>>Gerard