Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Password protect a dbf
Message
From
05/08/2009 12:47:01
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01415873
Message ID:
01416231
Views:
54
We use cipher5.fll, works with all versions of VFP, never had any problems so far.

You encrypt the data before writing to the table, like:

lnTest = "Hello World"
replace table1.field1 with encrypt(lnTest, YourKey)

The same call encrypts/decrypts, so reading is Store encrypt(table1.field1, YourKey) to lnTest

If a user tries to read the VFP data outside of your app, it is all encrypted.

If you want to go 1 step further and prevent them even seeing the encrypted data, add an audit trail like FoxAudit. The only way to see the data is if FoxAudit successfully instantiates itself, which would be very difficult outside of the VFP environment. Password protect the FoxAudit startup, and only the most determined hacker has a chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform