Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

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.
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.

Pete
blindpete@mail.com

What your mother told you is true! You will go blind! (from moonshine anyway)

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

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 lcRetStr
ENDFUNC

Jon Hawkins
jonscott8@yahoo.com

Focus on the solution....Not the problem.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close