How do you encrypt foxpro database files ? How do you encrypt foxpro database files ? randallJ (IS/IT--Management) (OP) 19 Sep 00 10:17 Other than moving to SQL Server, are there any utilities available to encrypt Foxpro database files. RE: How do you encrypt foxpro database files ? BlindPete (Programmer) 19 Sep 00 11:22 There is no native protection that I am aware of. I researched it a few years ago and there were several add-ons available for $$. I wrote my own cypher system once... but ultimately it was more trouble then the marginal security it provided me. (Not to mention the performance hit...)Perhaps someone else will no better. Peteblindpete@mail.comWhat your mother told you is true! You will go blind! (from moonshine anyway) RE: How do you encrypt foxpro database files ? foxdev (Programmer) 19 Sep 00 12:08 I've written a routine several years ago that uses SYS(15) to do very basic character-for-character encryption. Its pretty straightforward, but keep in mind there is a performance penalty in doing a lot of en/decrypting. I only used it for password fields.If you need more info on this technique, let me know. Robert Bradley FoxDev - Visual FoxPro Development RE: How do you encrypt foxpro database files ? jonscott8 (Programmer) 19 Sep 00 12:24 The bottom line answer to your question,AFAIK, is No. You can encrypt the data contained in VFP tables, but a user can still view/change the data. If you're wanting to secure your data, SQL Server is the way to go.Here's a snippet of simple encryption:FUNCTION Encrypt LPARAMETERS tcStr LOCAL x LOCAL lcRetStr LOCAL lcTrnStr *validate the parm IF TYPE('tcStr')<>'C' RETURN .F. ENDIF lcTrnStr=' FOR x=255 TO 1 STEP -1 lcTrnStr=lcTrnStr+CHR(x) ENDFOR lcRetStr = SYS(15,lcTrnStr,tcStr) RETURN lcRetStrENDFUNC Jon Hawkins firstname.lastname@example.orgFocus on the solution....Not the problem.