98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Password Protect
Password Protect
Resolved · Low Priority · Version Standard
Hamish has attended:
Access Introduction course
Access Intermediate course
Password Protect
Hi,
How do you password protect various tables or forms so that only certain people can edit the design of them but maintain the ability for all to enter data?
Ta.
Regards
Hamish
RE: Password Protect
Hi Hamish, Thank you for your post, welcome to the forum, in answer to your question;
I would consider using the Security Wizard option and would set up user groups and user rights.
This can be quite a complex operation to undertake and requires a considerable amount of care in setting it up; however if you do choose to follow this course of action;
Open your database in Shared Mode, and from the database window choose the Menu option Tools>Security and from the list choose User-level Security Wizard.
Follow the steps as advised by the Wizard to allow certain users/groups rights as required.
Note: as in all major changes it is advisable to practice this on a copy of your database or similar before 'going live'.
I hope that helps, best regards Pete
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. |
Access tip:Hiding rows and columnsTo hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column |