Nicholson, Karen
cyx5 at cdc.gov
Fri Jan 14 10:30:14 CST 2005
Inherited Database. Not my Fault! Government users are not yet ready to let go of this security file, even though I have all the security coded into the application based on their network login id. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, January 14, 2005 11:25 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] FW: Skip Over the Login Screen with a Shortcut " All of the security is set up in the .mdw file, so there is no need for passwords et all. Someone make my week productive, please?" Huh? What's secure about a system that does not require a password? True, you can assign user names to user groups and so restrict what a specific user can do. But if there are no passwords then all any user needs to do is find out what the user name is of someone with more rights, and bingo... off they go to unauthorized database browsing land. If you need security you need passwords - even if Access security not terribly strong. An alternative approach is to restrict what users can do based upon their LAN ID, then you can avoid using passwords to get into the database, but you'll have to roll your own 'security' code. I believe someone on this list has a lightweight security framework to do just that.. Lambert > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen > Sent: Friday, January 14, 2005 10:49 AM > To: accessd at databaseadvisors.com > Subject: [AccessD] FW: Skip Over the Login Screen with a Shortcut > > The original message was withheld because I put a screen shot in it. > With my luck, I will get thrown off this list for such an offense. > > > -----Original Message----- > > From: Nicholson, Karen > > Sent: Friday, January 14, 2005 10:40 AM > > To: Access Database Advisors (accessd at databaseadvisors.com) > > Subject: Skip Over the Login Screen with a Shortcut > > > > I think I have asked this before in some way or manner, but since my > > brain is mush this week, please forgive me if I ask it again. > > > > I want to skip this stoopid login prompt as none of the users even > > have a password. > > > > Login: cyx5 > > Password: > > > > The user's shortcut is: > > "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" > > c:\_Deims_sql\rb_sql.mdb /wrkgrp q:\_Deims_sql\rb.mdw /user cyx5 /pwd > > '' > > > > All of the security is set up in the .mdw file, so there is no need > > for passwords et all. Someone make my week productive, please? > -- > 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