password protect

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Password Protect

Password Protect

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Hiding rows and columns

To 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

View all Access hints and tips


Server loaded in 0.11 secs.