Jim Lawrence
accessd at shaw.ca
Fri May 29 18:00:24 CDT 2009
Well there you are... Your smarter than me... I am not a Access security guru. ;-) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, May 29, 2009 2:59 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Password on the Backend I found the answer on-line. Relink the tables, then Access 'knows' the password. Too simple. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Friday, May 29, 2009 2:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Password on the Backend Rocky, instead of putting a password on the backend, why not use Access User level security? If you use the same .mdw for the front and back end, when a use logs into the FrontEnd with a valid Username and Password, Access will automatically use those credentials on the backend. Just a thought.... Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, May 29, 2009 3:19 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Password on the Backend Dear List: I put a password on the back end and prompt for it in a pop-up in the opening form. However, now when I click a command button to open another form I get an 'invalid password' error. It doesn't look like the _Open event of the called form is executing. But the form is bound to tables linked to the back end. Does the OpenForm need a password parameter? Or what am I missing here? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- 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