Well I made some aplicatin wich want to close, crypt, not to see but with program, datas. (Foxpro 2.6, DOS). Yes there is some programs, libraries like Cipher or Xitech's Cryptor (btw anyone have this last one? I asked several times at Xitech, but they ignored me) but THE Question: if data gone to be crypted - how can I use index? Suppose that I go to put alphabetical key, index, how, for Gratious sake can I read (in alphabetical order)this data?; or - what to do to "lock" the file. For example file is locked, scrambled, non-readable when I try to read it outof my prgy. But when I approuch to it with program, program calls some external program or routine, or something and then I can read, write to file... Please gimme ideas. How, with what, etc... Regards.

All encryption and decryption has to be done within the program. You can recreate the indexes each time you need them. Otherwise erase them or create encrypted dummies.

What a simple solution!!!! Fred, THANK you! Really. :))) Now, only to find Xitech's cryptor (DOS Foxpro 2.6), but NO. I try to contact them, severel times - nada! They just ignored me. Oh-oh, one moment please! But if crypting is "on-fly" that means that only one record is encripted?! If I'm going to encrypt the whole base, copy, (re)index, what will hapened is someone break the program, or just through network approuch to the encrypted file?

At worse they would have to break the encrypted database. I assume that you would enter the key when you run the program. The database itself could remain encrypted but would be recognized as a database. You could re-encypt the database before you exit the program.