Elam, Debbie
DElam at jenkens.com
Thu Sep 22 13:09:35 CDT 2005
I liked this approach because it did not look like Access security to the users. They could even use the default .mdw as long as I left the admin password blank. It could be a bit of a pain to work on it, but I have an unsecured copy to work on and then reseure and deploy it. Debbie -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Thursday, September 22, 2005 12: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 - 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.