Passwords for Access database which restrict some users so they cannot change the data.
I am using Access 2007.
I have a Login Screen which asks for username and password. It allows for individual username/passwords.
Private-Sub-cmdLogin.docx
What I need to work out is how do I restrict some people's access. What I want is for the Admin person to have full access to change data obviously, but other people (committee members) to be limited to viewing the data or printing out reports.
Advice would be much appreciated.
I have a Login Screen which asks for username and password. It allows for individual username/passwords.
Private-Sub-cmdLogin.docx
What I need to work out is how do I restrict some people's access. What I want is for the Admin person to have full access to change data obviously, but other people (committee members) to be limited to viewing the data or printing out reports.
Advice would be much appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Was there some reason you closed this virtually identical question out without responding to any Expert comments (and awarding B grade):
https://www.experts-exchange.com/questions/27852115/Multiple-paswords-of-Access-database.html
Had you asked for more guidance in that question you very likely would have received it. Closing with a "B" grade without giving the Experts the courtesy of a "Thank you" won't win you many friends here ...
https://www.experts-exchange.com/questions/27852115/Multiple-paswords-of-Access-database.html
Had you asked for more guidance in that question you very likely would have received it. Closing with a "B" grade without giving the Experts the courtesy of a "Thank you" won't win you many friends here ...
ASKER
In response to LSMConsulting:-
Yes, there was a reason for giving points to people who had at least gotten me an answer to the part of my question about setting up a login screen and then starting this as a new Question - I had been told off once before for continuing on when I should have started a new Question! So I am a confused person who can't work out when to do what!
As for not giving you the courtesy of a Thank You, I am amazed, because, as I usually do, I wrote quite a lengthy Thank You to each and every respondent, including you, in which I explained how useful I found each referral - for instance, the WikiHow one appeared to be written for an earlier version of Access, and I was unable to work out how to translate that to Access 2007. I gave the bulk of the points to the respondent who had given me 4 referrals, three of which were effective, but I always give some points to any person who takes the time to answer me. You referred me to peterssoftware - my comment was that I preferred to learn, and therefore took the other advice.
What I cannot recall is giving a B, so I make no apologies for something I cannot recall.
WHY my response did not get recorded is beyond me. I have often written a response several times over because it simply disappears - there is no provision for saving a draft while I go and check something else - like look up a previous question. To check this, I just opened another of my questions 9without asking to open in a new tab), and sure enough when I came back this response had disappeared - but this time I had been smart enough to copy this text, just in case, otherwise I would be typing it all again.
My apologies for offending you, or the other respondents, even though it was unintentional.
Yes, there was a reason for giving points to people who had at least gotten me an answer to the part of my question about setting up a login screen and then starting this as a new Question - I had been told off once before for continuing on when I should have started a new Question! So I am a confused person who can't work out when to do what!
As for not giving you the courtesy of a Thank You, I am amazed, because, as I usually do, I wrote quite a lengthy Thank You to each and every respondent, including you, in which I explained how useful I found each referral - for instance, the WikiHow one appeared to be written for an earlier version of Access, and I was unable to work out how to translate that to Access 2007. I gave the bulk of the points to the respondent who had given me 4 referrals, three of which were effective, but I always give some points to any person who takes the time to answer me. You referred me to peterssoftware - my comment was that I preferred to learn, and therefore took the other advice.
What I cannot recall is giving a B, so I make no apologies for something I cannot recall.
WHY my response did not get recorded is beyond me. I have often written a response several times over because it simply disappears - there is no provision for saving a draft while I go and check something else - like look up a previous question. To check this, I just opened another of my questions 9without asking to open in a new tab), and sure enough when I came back this response had disappeared - but this time I had been smart enough to copy this text, just in case, otherwise I would be typing it all again.
My apologies for offending you, or the other respondents, even though it was unintentional.
ASKER
To madshiva and Graham, I will work through your suggestions - thank you for your input - and I will be back either with further questions or with thanks
ASKER
My apologies, I have been unwell, and haven't been able to utilise this information as yet.
Thanks to all of you.
Thanks to all of you.
ASKER
Even though I have been unable to test the advice as yet, I have given an A Grading, because what I read has made sense.
Thanks for the usefull information and other way to implement this.
Has for the username depend on the security that apply on the computer I don't have succesfully spoofed the username, but anyway it's better with the windows API :)
Regards