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

access

ResolvedVersion 2007

Paul has attended:
Access Advanced course

Access

Can different users be given different passwords to access the database or is this a VBA element?

RE: Access

Dear Paul

Thank you for attending Access 2007 Advanced course!! I hope you enjoyed the course and benefited from it.

In the Database Tools in the Administer group you have the options of creating different users and groups when you choose user and group permissions and giving them different permissions such as read only, etc... rights to the users.

But if you want to assign passwords to the users then choose User and Group accounts where you can set passwords for different user or group.

You can also use the wizard to help you create users and groups and then set passwords for them.

If you want certain users to have same rights or permissions then it is recommended that you put them in the same group and then assign the password and the permissions for the group which is much faster!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

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.09 secs.