Microsoft Access
  Home arrow Microsoft Access arrow Page 4 - Securing and Administering Access
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Securing and Administering Access
By: McGraw-Hill/Osborne
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 13
    2004-09-14

    Table of Contents:
  • Securing and Administering Access
  • Secure the Database with the User-Level Security Wizard
  • Groups
  • Add, Edit, and Remove Users
  • Save or Print the Security Report
  • Apply Global Database Protection to a Database
  • Remove Database Objects from View
  • Back Up and Restore a Database
  • Back Up Individual Database Objects
  • Database Administration
  • Compact and Repair a Database

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Securing and Administering Access - Add, Edit, and Remove Users


    (Page 4 of 11 )

    In the next Security Wizard dialog box, shown in Figure 9-6, you can get specific about which users to add to the workgroup. You can also delete a user from the workgroup and edit a user’s password or PID.

    Figure 9-6: The Security Wizard allows you to add users to and delete users from the workgroup.

    Securing the Access Database

    To add a new user:

    1. Click Add New User in the left pane.

    2. Type a name in the User Name text box.

    3. Type a password in the Password text box.

    4. The user’s PID is automatically entered, but you can change it if you want to.

    5. Click Add This User To The List.

    6. Repeat Steps 1 through 5 to add other users to the workgroup.

    To remove a user from the workgroup, select the name and click Delete User From The List. To edit user information, select the name and change the password or PID. Click Next when fi nished with the users in the workgroup.

    Assign Users to Groups
    The final major step in defining user-level security is to assign each user to one of the groups that you have selected. You have two ways to carry this out in the next Security Wizard dialog box, as shown in Figure 9-7. You may start with a user and add the user to groups, or start with a group and assign users to it.

    Figure 9-7: You can assign users to groups or groups to users.
    Securing the Access Database

    1. In the next dialog box, click Select A User And Assign The User To Groups. The user names you added to the workgroup appear in the Group Or User Name drop-down list. The group names you included appear in the pane below the list.

    2. Click the Group Or User Name down arrow and select a user name from the list.

    3. In the lower pane, select each group name that you want the user to be a member of.

    4. Repeat Steps 2 and 3 to assign other users to groups. Then click Next.

    5. In the final Security Wizard dialog box, enter a name and path for the unsecured backup database, and click Finish.

    NOTE  You can assign a user to more than one group. The user then has all the permissions associated with all the groups she belongs to.

    NOTE  When you assign users to groups in the Security Wizard, if you choose Select A Group And Assign Users To The Group, you select the group name in the Group Or User Name drop-down list and select the user names from the list below it.

    This chapter is from Microsoft Office Access 2003 QuickSteps, by Cronan, Anderson, and Anderson (McGraw-Hill/Osborne, 2004, ISBN: 0072232293). Check it out at your favorite bookstore today.

    Buy this book now.

    More Microsoft Access Articles
    More By McGraw-Hill/Osborne


       · some time ago it was said that the workgroup file is needed to break into a secured...
       · I\'m not sure about Access2003... but every other version of access that uses the...
     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
    Stay green...Green IT