Forum home » Delegate support and help forum » Microsoft Access Training and help » training database microsoft access - Security
|
|
|
The UK's most regular Training information:
See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
training database microsoft access - Security
Resolved · Low Priority · Version Standard
Reply Tue 25 Sep 2007, 16:55Delegate Leigh said...
Leigh has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Security
How do i lock and make my databases read only to certain individuals
For upcoming training course dates see: Pricing & availability
RE: Security
Dear Leigh
To make your database Read Only to certain individuals you need to create a Workgroup
In the workgroup you would then set up Groups and Users to which you would give permission levels to use the database (eg Read Only) or to use only certain parts of the database.
The problem is that to do this your IT department will have to give you FULL Administrator access to the network.
To set Security settings:
1. open the Tools menu
2. Select Security
3. Set a password that locks the whole database OR Set the Group/User permissions
Hope this helps
Carlos
Reply Fri 12 Oct 2007, 10:58Delegate Leigh said...
RE: Security
Thanks for that Carlos.
I'm now having trouble working out the assigning of groups and users permissions.
RE: Security
Suggest reading through the HELP file under "user level security". Access security is indepth and a bit complex, so hang in there. Have you managed to get a working solution so far?
Reply Tue 23 Oct 2007, 11:48Delegate Leigh said...
RE: Security
Yeah i have thanks, i will be doing the advanced course in a couple of weeks hopefully that will help me with it all aswell.
RE: Security
Leigh
Hope you enjoy the course and get all you need from it
Carlos
|