luciliacoelho
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
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
Security topic was discussed e.g. here: https://www.experts-exchange.com/questions/26340066/foxpro-database.html?sfQueryTermInfo=1+10+30+foxpro+imperson