Forum home » Delegate support and help forum » Microsoft Access Training and help » best training access course - User names and password
|
|
|
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. |
best training access course - User names and password
Resolved · Low Priority · Version Standard
Reply Thu 18 Oct 2007, 17:20Delegate Sue said...
Sue has attended:
Access Intermediate course
User names and password
how do you put a password on the system so other people cannot edit data
For upcoming training course dates see: Pricing & availability
RE: user names and password
Try Tools > Security > set Database password
This will give protection to the entire database when you open it. If you have the password, you can change data, if not, then no access to the database at all.
Reply Tue 23 Oct 2007, 09:18Delegate Sue said...
RE: user names and password
Hi Richard
Thank you for your reply, if I follow the instructions you have advised I am right that other users will not be able to open the database. If so that is not what I want to achieve I want all users in the office to be able to view the database but onoy one or two users able to edit data. Please confirm best way to achieve this.
Thanks
Sue
RE: user names and password
You would need to look into USER LEVEL SECURITY.
I will warn you upfront, that it is indepth and a bit complex. If you or any colleagues understand User Level permissions using microsoft windows servers, then the job will be easier.
Firstly I suggest that you make a copy of your database, and test your security on that database. You may find that you end up locking yourself out completely, and need to start again. If this happens, delete the database file completely (even from the recycle bin), and general accesss will be restored to ACCESS).
The first place to start is to look in the HELP section for "user level security". Read through all the details, and then run the wizard.
In this way, you will be able to assign specific permissions for specific users and groups on specific objects. It takes some planning and patience.
That will get you pointed in the right direction. Let me know if you have any further questions.
Richard
|