General discussion

Locked

Protecting data into VFP5 database

By scalinica ·
I have a table into a Visual FoxPro 5 database. Some fields of the table contains readable text. I want to protect this information in such manner that third-party software not to be able to supply intelligible data from those fields.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Protecting data into VFP5 database

by Stillatit In reply to Protecting data into VFP5 ...

From the technical side, if you must stay with Visual Foxpro the only real way to do this is for your application to encrypt the data before writing it and decrypt after reading it. Otherwise anybody with read access to the file can find the data using a copy of Foxpro, Access, or, for that matter, the DOS 'type' command. The implication is that to protect the privacy of your data you need to either move the data out of Foxpro or deny read access to people who should not have it.

If you can afford the cost and effort to put the actual data on an SQL server you can restrict access a bit better since you can limit access by field to certain users. Converting your Fox program to use SQL server is not usually easy.

If you have an NT or W2K server or workstation, here is another approach.

1. Break the database into two .dbf files, one with the less sensitive information, another with the more sensitive information. (There may turn out to be more than two divisions, depending on how many groups of people you need to distinguish between.)

2. Put each database and associated index files in its own folder on an NTFS partition of an NT (or W2K) machine. Set the folder and file permissions and share permissions to allow only those users who should see the data to have access.

3. Modify your Foxpro program so that users who should not see the sensitive data do not attempt to USE the file(s) which contain that data (since the USE command will fail).

Good luck.

Collapse -

Protecting data into VFP5 database

by scalinica In reply to Protecting data into VFP5 ...

Thank you for answering me.

Collapse -

Protecting data into VFP5 database

by scalinica In reply to Protecting data into VFP5 ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums