A couple of years back with the help of people on here I set up a database for my Carpet shop that deals with everything from day to day running of the shop to keeping track of all the financial stuff. To cut a long story short we have just had to take on a member of staff and I want it so he has access to certain aspects of the database that I have set up. There are certain areas that I do not want him to see ie. Money due in and money due out etc. I know I can put a password on the whole database but I just wonder if there is any way that i can put a password on certain forms and things so that he cant access them. Any help would be greatly appreciated.
Password Access Help
- Thread starter MartL
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 07:12
- Joined
- Nov 30, 2011
- Messages
- 8,494
If you want to hide information, and grant access to view them by password entry, then you can make use of my Password Box - A variant of Input Box.
Alansidman
AWF VIP
- Local time
- Today, 01:12
- Joined
- Jul 31, 2008
- Messages
- 1,493
This is an alternative way to go:
http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html
http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html
Thanks guys. At the moment we only use a single log on for the computer so Im not sure Alans version would work but its something maybe we need to look at. @pr2-eugin Would you mind explaining to me how that all works and what to do with the working module that you posted. Although I have an idea of the basics most of my DB was put together by reading a book and a lot of the things I have simply forgotten so its a bit like starting over for me again.
pr2-eugin
Super Moderator
- Local time
- Today, 07:12
- Joined
- Nov 30, 2011
- Messages
- 8,494
Okay before going into the method which you wish to implement, we need to determine what method would actually work for you..
My version : In my application, payment information like Bank information, Payment information are all put in a tab and is hidden, I have a button on the same form where it says "View pay info." On click a Password input box will pop up where authentication is sought, if the password is verified the user will have access to view the information. Else a message box will come up saying "No information can only be viewed by management".
Denis version (via Alansidman) : Will restrict what objects a user can view and edit.
So you have to see which version sounds more appropriate for your application. IMO, I think you need Denis's soultion. If that is not the case, explain a bit more on how you intend to use it.
My version : In my application, payment information like Bank information, Payment information are all put in a tab and is hidden, I have a button on the same form where it says "View pay info." On click a Password input box will pop up where authentication is sought, if the password is verified the user will have access to view the information. Else a message box will come up saying "No information can only be viewed by management".
Denis version (via Alansidman) : Will restrict what objects a user can view and edit.
So you have to see which version sounds more appropriate for your application. IMO, I think you need Denis's soultion. If that is not the case, explain a bit more on how you intend to use it.
Ok Thanks.
On booting up the computer we dont have any user accounts the computer just boots to our main user account.
Our Database once loaded contains all our customer information like invoices, and what the customer has ordered. We want our member of staff to be able to access our main screen and also to be able to input new invoices and look at old invoices freely.
We also want him to have access to all the prices for our products and be able to add new ones if the need arises. We have some accounts things on there that I would prefer that he wouldnt have access to. Things like how much money we are due in and out and also weekly and monthly figures which we want to keep private.
If need be I could post a dummy of the DB if that would help.
On booting up the computer we dont have any user accounts the computer just boots to our main user account.
Our Database once loaded contains all our customer information like invoices, and what the customer has ordered. We want our member of staff to be able to access our main screen and also to be able to input new invoices and look at old invoices freely.
We also want him to have access to all the prices for our products and be able to add new ones if the need arises. We have some accounts things on there that I would prefer that he wouldnt have access to. Things like how much money we are due in and out and also weekly and monthly figures which we want to keep private.
If need be I could post a dummy of the DB if that would help.
pr2-eugin
Super Moderator
- Local time
- Today, 07:12
- Joined
- Nov 30, 2011
- Messages
- 8,494
MartL, so what you need is to look at creating a table with employee details a login form etc. as Denis has explained in the post. I would suggest you follow the steps described and you will be able to do it.
If you are stuck at any point post back and someone will be along the way to help you out.
If you are stuck at any point post back and someone will be along the way to help you out.
Similar threads
