Jim Lawrence
accessd at shaw.ca
Thu Sep 22 13:31:25 CDT 2005
Hi Rocky: The only way to protect the data is to have it kept internally. Looking at the Sleep Advisor application there is very little data that is stored. If the program stored the data internal in an array or series of arrays that would solve the problem. The downside is that you will have a lot more work to do. HTH Jim -----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 10:26 AM 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