Link to home
Start Free TrialLog in
Avatar of luciliacoelho
luciliacoelhoFlag for Portugal

asked on

how can i protect my dbf files

how can i protect my dbf files to be oppened by Excel ou another program?
thanks
ASKER CERTIFIED SOLUTION
Avatar of TAMUG
TAMUG
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pavel Celba
Avatar of jrbbldr
jrbbldr

A 3rd way to do it would be to create your data table files with a different file (non-DBF) extension.

This would not prevent someone from opening the file in Excel, but with a non-DBF file extension, Excel would not recognize it as a file type that it can open.

cDataDir = "F:\VFP Data"
cDBF = ADDBS(cDataDir) + "MyData.001"
USE (cDBF) IN 0 ALIAS MyData
SELECT MyData
<do whatever>

Good Luck


And yet another way would be to change from using VFP DBF files and migrate your data into a SQL Server 'backend'.  

Your application can continue to work as a 'front end' to your users and incorporate the SQL Server data tables as the data source.

Then you could use the SQL Server security management to limit access to the tables.

Good Luck