>We all know that data security on the native foxpro table is not supported by the system. But aside from using other back-end systems
>(SQL-Server,Oracle) , is there any other way or technique wherein we can hide the tables to prevent users from opening the tables using other software applications (eg Excel).
Two techniques (besides encryption) used here are:
1) Use the '$' in the dir sharename to hide it from prowling users. Not foolproof, but the average user will have trouble.
2) Divide your data up into different dirs and restrict access to only certain users/certain dirs.
#2 is the best solution, if/when possible.
Note that encryption doesn't stop drastic actions like sabotaging the data...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.