>I was under the impression that in VFP 7.0 , we could protect the tables buy using ' Events '. Other day, I read a message that if VFP is installed on target machine, then its possilbe to remove the ' condition ' & easily modify the data in the tables.
>
>We were evaluating if we should use VFP or VB/Access for our next project. Can Access files be made secure ?
>
>Regards
>Rakesh
For your production database, you can always delete the source code from the DBC to prevent hacking. What I do in my SP is in the BeforeOpenTable event, I have the following code:
IF VARTYPE(oApp) <> "O"
RETURN .F.
ENDIF
When my app is lauched, I create the global app object, oApp. To remove the uncompiled source code from the DBC, open the DBC as a table with the USE MYDBC.DBC command. Go to the record whose ObjectName is StoredProceduresSource. Delete the code from the CODE field. The compiled code is in the next record. Make absolutely sure you have the uncompiled code in a copy of the DBC on your development computer. You also can not COMPILE DATABASE on this DBC until you put the source code back.
Mark McCasland
Midlothian, TX USA