 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Using Access Security
Is there anyway to have a secure database where a person can't access the passwords that are stored expect to change their own password? Thnaks, J. > Is there anyway to have a secure database where a person can't access > the passwords that are stored expect to change their own password? With standard user level security nobody has access to anyone's password but their own. Administrators can clear a password or even assign a password, but they cannot "see" a password once it is set.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com How is this done? At the moment I just have a table. > > Is there anyway to have a secure database where a person can't access > > the passwords that are stored expect to change their own password? > > With standard user level security nobody has access to anyone's password but > their own. Administrators can clear a password or even assign a password, > but they cannot "see" a password once it is set. How is this done in Access 97? I am just using a table. > > Is there anyway to have a secure database where a person can't access > > the passwords that are stored expect to change their own password? > > With standard user level security nobody has access to anyone's password but > their own. Administrators can clear a password or even assign a password, > but they cannot "see" a password once it is set. How is this done in Access 97? I am just using a table at the moment. I have different levels for different forms. If I use Access's built in security how do I access it so that I can have certain people access/deny access to various forms and reports. Sorry for hte extra posting - just realised I should have asked in more detail. Thanks, J. > > > Is there anyway to have a secure database where a person can't access > > > the passwords that are stored expect to change their own password? [quoted text clipped - 3 lines] > > their own. Administrators can clear a password or even assign a password, > > but they cannot "see" a password once it is set. >How is this done in Access 97? I am just using a table at the moment. I have >different levels for different forms. If I use Access's built in security >how do I access it so that I can have certain people access/deny access to >various forms and reports. >Sorry for hte extra posting - just realised I should have asked in more >detail. Download the Microsoft Access 2000 Security FAQ: http://support.microsoft.com/kb/207793/en-us Don't worry, it was not changed significantly between 97 and 2000. Print this document out. READ IT, CAREFULLY. Get a good night's sleep. Reread the FAQ, even *more* carefully. Security is complex and it's easy to do it wrong! You can make a database inconvenient for users and dead easy for anyone knowledgable to break in; you can even lock it up so NOBODY, even you, can get in. Follow the checklist, step by step. It's straightforward if you follow the steps and do it completely. SignatureJohn W. Vinson [MVP] Thanks, It does say it covers version 2.0 (Office 6). > >How is this done in Access 97? I am just using a table at the moment. I have > >different levels for different forms. If I use Access's built in security [quoted text clipped - 20 lines] > Follow the checklist, step by step. It's straightforward if you follow the > steps and do it completely. I've downloaded the mde file also: frmaccounts and frmmain generate errors: with block witout set. can't get into the modules including froms so looks like this file is of no use. > >How is this done in Access 97? I am just using a table at the moment. I have > >different levels for different forms. If I use Access's built in security [quoted text clipped - 20 lines] > Follow the checklist, step by step. It's straightforward if you follow the > steps and do it completely. >I've downloaded the mde file also: frmaccounts and frmmain generate errors: >with block witout set. can't get into the modules including froms so looks >like this file is of no use. I'm sorry, I have NO idea what you're talking about here. The Security FAQ is a WORD document. You print it out and read it. SignatureJohn W. Vinson [MVP] the doc makes reference to the mde file which I also download. My approach is: 1. check if file exists then allowbypass keys are either true or false - already done 2. Table in access that holds users - already done 3. Want to prevent access by either going file-1 (already done with 1) and by linking from another database. 4. Hoping to usie Access Security to acheive this where table access is handled by 1 and 2 and form and report access is by using the internal/linked table in combination with Access Security (I.E. Name in table links to name in Access Security so local mangers can just say user has 0 restriction to level 9 restriction in the security form I've already created). > >I've downloaded the mde file also: frmaccounts and frmmain generate errors: > >with block witout set. can't get into the modules including froms so looks [quoted text clipped - 3 lines] > > The Security FAQ is a WORD document. You print it out and read it. |
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.