>>i want to prevent users from using comands like EDIT/BROWSE to view tables in a database. can someone enlighten me as to how i can achieve this or are there some products available that would achieve the above result.
>
>As Hilmar said, Hallogram sells Cryptor. For what I hear it's a good product for encrypting whole talbes on the fly.
>
>But if you have data security issues I would also recommend a move to SQL Server as a more secure and robust DB. VFP (especial VFP9 but all versions do) work very nicely with SQL Server.

Hi Alex. I have been trying Cryptor for a while now. It works just great, straight out of the box. Includes strong crypto like DES, Blowfish, and AES. What I like most is that it really is a case of encrypting the files and loading the dll in your app. It takes care of the rest so it is an easy solution to implement.