 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2006password protect
i need a suggestion on how to best setup a password. i will have a dialog that asked how the main form is to be viewed. a password will be required if the user wants to access the main form in using an admin role. if the password is valid all fields on the main form will be unlocked and editable. otherwise they won't get passed the login form unless they accept a lesser role. so the question is where/what is the best place/method to hide the passowrd? i will not use the access security. tia, mcnewsxp Please do a search and read the hundreds of previous posts on the topic. Most of them will recommend that you use the built-in User Level Security. They will point out that rolling your own security will be much easier to get around than using the proper tools. Most will point out how annoying it will be for your upper-level employees to be forced to enter a password every time they want to do their job. Several of those posts do point to resources that explain how to build a password-protected form or function though. Good Luck!  SignatureRick B >i need a suggestion on how to best setup a password. > i will have a dialog that asked how the main form is to be viewed. [quoted text clipped - 12 lines] > tia, > mcnewsxp > > so the question is where/what is the best place/method to hide the > > passowrd? > > > > i will not use the access security. any other takers? thanks, mc >> > i will not use the access security. > > any other takers? I sincerely doubt it. User-level security, though flawed, is head 'n' shoulders above any home grown solution I've seen. My advice - take Rick B's advice. Keith. > >> > i will not use the access security. > > [quoted text clipped - 3 lines] > shoulders above any home grown solution I've seen. My advice - take Rick > B's advice. i work in an environment that has given me the benefit of experience with the access user -level security. people's files are moved around a lot here and always results in the mdb becoming in-accessable. If files are moved around a lot then there seem to be problems on top of the Access issues. Splitting the database may offer something of a solution, depending on your needs. As Rick suggested, try a search for password-protected forms if you refuse to use Access user-level security (which is different from the database security you can select from the menu). It is difficult to make home-grown security effective, but if all you are trying to do is to keep honest people honest then it may be enough. >> >> > i will not use the access security. >> > [quoted text clipped - 7 lines] > with the access user -level security. people's files are moved around > a lot here and always results in the mdb becoming in-accessable. > > > > > i will not use the access security. > > > [quoted text clipped - 7 lines] > with the access user -level security. people's files are moved around > a lot here and always results in the mdb becoming in-accessable. If moving a file results in not being able to open it then you are not doing user level security properly. Any user with a passing acquaintance of Access could bypass home-grown security with virtually no effort at all. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com > i work in an environment that has given me the benefit of experience > with the access user -level security. And ... ? > people's files are moved around > a lot here and always results in the mdb becoming in-accessable. You could always use file permissions to stop that from happening to the back end and mdw file and deploy a copy of the front end to each user's HDD. Keith. www.keithwilby.com > > i work in an environment that has given me the benefit of experience > > with the access user -level security. [quoted text clipped - 6 lines] > You could always use file permissions to stop that from happening to the > back end and mdw file and deploy a copy of the front end to each user's HDD. i have no control over what users and network admins forget to do. >> > i work in an environment that has given me the benefit of experience >> > with the access user -level security. [quoted text clipped - 9 lines] > > i have no control over what users and network admins forget to do. Some folks just don't want to be helped. <PLONK> > >> > i work in an environment that has given me the benefit of experience > >> > with the access user -level security. [quoted text clipped - 13 lines] > > <PLONK> some folks can't read. the network environment i work in is not at this point one in which i can trust that network admins and users will remember to do what they need to do with their important files and data. i know all about user level security. i have experienced the problem that i described too many times sometimes i don't deal with my clients for a couple of years and when i do hear from them all they want me to do is unlock their mdb because they can't get into it anymore. i appreciate you folks who are attempting to *school* me on the proper rules, but sometimes what you learn in school ain't what happens in the real world. so if anyone could simply respond to my request as posted that would be swell. BTW - i did the search and didn't find any useful suggestions so i will cobble together my own version of password proctection. best, mc > so if anyone could simply respond to my request as posted that would be > swell. Not gonna happen. > BTW - i did the search and didn't find any useful suggestions so i will > cobble together my own version of password proctection. Does anyone have any useful suggestions for developing their own wheel? I have one with corners, is there a flaw in my design? > > so if anyone could simply respond to my request as posted that would be > > swell. [quoted text clipped - 6 lines] > Does anyone have any useful suggestions for developing their own wheel? > I have one with corners, is there a flaw in my design? how many dumbasses does it take to answer one question the way is was asked? If you want to try a home-grown setup have a look at http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=373275&page= 1&view=collapsed&sb=5&o=&fpart=1 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.