Path: csiph.com!eternal-september.org!feeder.eternal-september.org!border1.nntp.ams1.giganews.com!nntp.giganews.com!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer04.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Urs Eggmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Encrypting data in DBF file Date: Mon, 19 Jun 2017 22:46:27 +0200 Lines: 60 Message-ID: References: <691ec839-e8ee-4a71-a067-a8c4e1ca70b3@googlegroups.com> <8ae5a1da-1714-4c1f-ae44-6a200adaa7c6@googlegroups.com> <59280bd0-b66a-4026-b67a-e51d289db700@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net xmUKSnw6Sz1aMIqaYiMQAgzw+w+yD1OByMxZvg5AzZjs44nGR4 Cancel-Lock: sha1:nkRf5zCRAld0n/oF7lJQplJZ780= X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-EsetId: 37303A29ABFDDD64627265 X-EsetScannerBuild: 33776 X-Received-Bytes: 3043 X-Received-Body-CRC: 484457473 Xref: csiph.com comp.lang.clipper.visual-objects:10702 Hi Simon, On t h website of the user group Bodensee ( www.voug-bodensee.net ) you can find two samples for encrypting db files: CryptoFalle.zip And CryptDB.zip A trap you can fall in are the blanks at the end of a field content. If you encrypt a string, that is shorter as the field length, the blanks at the end are also encrypted and savet to the field. On decryption of e fieldcontent, the resulting string contains blanks. regards Urs schrieb im Newsbeitrag news:59280bd0-b66a-4026-b67a-e51d289db700@googlegroups.com... > On Monday, June 19, 2017 at 3:32:31 PM UTC+1, dlzc wrote: >> Dear si...: >> >> On Monday, June 19, 2017 at 1:52:44 AM UTC-7, si...@abersoftware.co.uk >> wrote: >> ... >> > Anyone have any thoughts on best way to encrypt data >> > fields that are stored in DBF file. >> > >> > The reason is just to stop people looking at the DBF >> > file from outside the application. >> >> Move from DBF to SQL. >> ... or ... >> Move DBF to server, and only provide access to the DBF data via Terminal >> Services. >> ... or ... >> Use the methods of a hierarchical database, and keep data in several >> different "synced" data files. >> ... or ... >> Can also copy/move/reattrib the DBF from a hidden directory or state, as >> the first step in program execution, while your splash screen displays. >> >> ... for "lightweight" (non run-time intensive) methods. >> >> David A. Smith > Hi David, > > I like the idea of the hidden file but want to keep installation and setup > as simple as possible. > > Moving to SQL would be nice but no time at the moment. Will switch > eventually though. > > Having the field encrypted in the datafile gives some level of protection > and if the IT people secure their systems properly then will be fine for > my case. > > I just need to test on a few different systems to make sure it doesn't > mess up with different character sets / conversions etc. > > Simon