Heenan, Lambert
Lambert.Heenan at AIG.com
Thu Sep 22 14:00:35 CDT 2005
It's a very very simply way of scrambling text data - I wouldn't go as far as to say it is encryption). See http://en.wikipedia.org/wiki/ROT13 http://searchsecurity.techtarget.com/sDefinition/0,,sid14_gci214517,00.html See also http://vbnet.mvps.org/index.html?code/algorithms/rot39.htm for an Rot-39 algorithm, which has the advantage of also encoding non-alpha characters. Again, none of this is strong encryption or even close. They simply give a fast way to make the data LOOK weird. To use this method all your forms would ROT39 encode the data as it is saved to the tables, and the queries would use the exactly same routine to translate them. Alternatively, if you want to use bound forms you would save plaintext data to the tables and then use an update query to ROT39 encode the new record. If, as has been suggested, you save all your queries as text in code modules then there would be no queries visible to import, and so the nosey user would not immediately see that they were all calling rot39 to translate the data. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, September 22, 2005 1:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Stopping import of tables and queries from mde Lambert: Whuzzat? (ROT-13. It sounds dreadful.) Rocky ----- Original Message ----- From: "Heenan, Lambert" <Lambert.Heenan at aig.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Thursday, September 22, 2005 10:40 AM Subject: Re: [AccessD] Stopping import of tables and queries from mde > What if you just ROT-13 encode all the text. To the casual eye it will > look > like garbage. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin - Beach Access Software > Sent: Thursday, September 22, 2005 1:26 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Stopping import of tables and queries from mde > > > Boy, I'd like to avoid Access security if possible. This is The Sleep > Advisor and it's going out on a self installing CD to consumers. > > 99 and 44/100ths of them won't have Access or any idea (or desire) to > look at the tables. But all of our output text is in the tables. And > if someone > > wanted to try a knockoff they could see some of the approach I used to > do the analysis and reporting. They could also get to all the text. > It would be copyright infringement but we'd have to take action to > enforce it which is a losing proposition. > > So I'm just trying to add that extra layer of protection. > > > Rocky > > ----- Original Message ----- > From: "Elam, Debbie" <DElam at jenkens.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Thursday, September 22, 2005 10:16 AM > Subject: Re: [AccessD] Stopping import of tables and queries from mde > > >> Could you implement Access security that restricts the Admin login to >> data entry? I did this with a database to restrict entry, but not >> viewing. Admin was left with a blank password, so the Admin user >> worked like it was unsecured, until the user tried to exceed the >> permissions set. >> >> Debbie >> >> -----Original Message----- >> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] >> Sent: Thursday, September 22, 2005 12:02 PM >> To: AccessD at databaseadvisors.com >> Subject: [AccessD] Stopping import of tables and queries from mde >> >> >> Dear List: >> >> I have an mde which is going to be distributed as a consumer product >> (Wise/Sagekey install). However, I see that even though I thought I >> had the mde all locked up, anyone with Access can still import the >> tables and queries. >> >> Is there a way to prevent that without causing problems in the >> product? >> >> MTIA, >> >> Rocky Smolin >> Beach Access Software >> http://www.e-z-mrp.com >> 858-259-4334 >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) >> subject to the Attorney-Client Privilege, (2) an attorney work >> product, or (3) strictly confidential. If you are not the intended >> recipient of this message, you may not disclose, print, copy or >> disseminate this information. >> If you have received this in error, please reply and notify the sender >> (only) and delete the message. Unauthorized interception of this e-mail >> is > >> a >> violation of federal criminal law. >> This communication does not reflect an intention by the sender or the >> sender's client or principal to conduct a transaction or make any >> agreement by electronic means. Nothing contained in this message or >> in any attachment >> shall satisfy the requirements for a writing, and nothing contained >> herein >> shall constitute a contract or electronic signature under the Electronic >> Signatures in Global and National Commerce Act, any version of the >> Uniform >> Electronic Transactions Act or any other statute governing electronic >> transactions. >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com