security
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Security

Security

resolvedResolved · Low Priority · Version 2003

replyReply Tue 8 Apr 2008, 15:46Delegate Jamal said...

Jamal has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Security

How do I introduce user security/levels

For upcoming training course dates see: Pricing & availability

replyReply Thu 24 Apr 2008, 10:35Trainer Pete said...

RE: Security

Hi Jamal, thanks for the post, welcome to the forum, in reply to your question, sorry its taken so long, but I've just noticed that it hasn't been replied to:
Security User levels can be applied to your database quite quickly if you are prepared to use the Database Security Wizard, in fact this is probably the best way of setting security levels in a small to medium sized user base.
Menu command Tools>Security>User-Level Security Wizard, you can then follow the setup steps as per your requirements to set user rights, following from this you might want to attempt the User and Group Permissions and the User and Group Accounts manually, make sure that you try this out in a Copy of your database, in a separate folder to the original as a small error or ommission can cause disastrous results. I wish you luck, best regards Pete

 

Please browse our web site to find out more about
access+courses+in+london and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard