> Hi Experts
>
> I am facing problem of Data Base Security. Users at user end open table in browse window and change data manually and blaming me that my software automatically changes their data. No body is accepting the responsibility. Some of my friends are saying me to shift to SQL Data Base and leave VFP becase its data is unsecured. I am using Free Table. If I shift then is it my correct decesion. Is VFP have no solution at all for this kind of problems.
>
> Tnnx in advance
>
> Ahsan Rana

In addition to what Tushar told you, remember that there are additional costs, as well as major changes to your application code, to changing to another database. You SHOULD use a DBC though and, since you are working in VFP 7.0 you can use Database Events to control access to your data from outside the application.

Check out "Database Container Events" in the help file - specifically you need to use dbc_BeforeOpenTable and test to see if your application is running (check for some variable, object or property) and if it isn't, just return .F. That will stop users from opening the tables outside of the application by using VFP and Browse!

However, it will NOT stop users from accessing the data with hacking tools or programs.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA