>>>Is there a property in VFP 9 database (or a VFP setting) that would make all tables of the database to be read only?
>>>
>>>What is it that you are trying to accomplish here?
>>
>>I have some customers that I am converting to SQL Server database (from VFP). The VFP database and tables are still on their drive and could theoretically be accessible. I would like to prevent it without actually deleting the VFP database.
>
>As the others have stated, nothing totally foolproof available,
>Setting permissions on the enclosing folder a step with acceptable reward/effort ratio.
>
>You might add another security layer by checking with the DBC-Events that the tables are really read-only.
>Again, easily overcome - not existant if not opened via VFP or VFP-ODBC/OLEDB driver.
>You might just show a big warning screen in the event if the dbf is not read-only
>[and add a email to you with a log of when this happened, under which login]
>But if someone just uses a Hex-Editor this wont get triggered.
>
>That assumes all your tables are already DBC-housed as "database" is in the msg title,
>otherwise don't bother with this step, as it adds only little more benefit
>and adding dbc when leaving tables for SQL is not worth it - of course I know no specifics on your data worth.
>
>regards
>
>thomas

First, thank you all for your input.

The tables do belong to a database (that is housed with DBC). I am not concerned if a table is being accessed by Hex-Editor or any other way outside of my (VFP) application. I am only concerned that somewhere I didn't leave out code in my application that by accident still opens VFP table(s) instead of getting the data from SQL Server. Another thing, I cannot get rid of the VFP tables and database because the application relies on them. The part that relies on the VFP tables and DBC is Stonefield Query (not the latest version but an older, no longer supported). So I suppose setting the tables to read-only is the only approach. But I need to check to be sure that my Stonefield Query will still work with tables set as read-only.