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

password protect

ResolvedVersion 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:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.