Microsoft Access
  Home arrow Microsoft Access arrow Page 3 - 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 - Groups


    (Page 3 of 11 )

    Set Up Group Accounts
    Setting up group accounts involves choosing the appropriate groups for your application based on the tasks assigned to the users. In the next dialog box, shown in Figure 9-4, you can view which permissions are assigned to specific security groups, and then decide how to assign the users to the different groups. A unique group ID is assigned to each group by the Security Wizard.

    Figure 9-4: The security group accounts provide specific
    permissions to their members.
    Securing the Access Database

    CAUTION  The default Users group provides access to all objects in a database. Everyone who has a copy of Access is automatically a member of the Users group and will have the same permissions applying to all open databases.

    1. Select a group in the group list to read the description of the permissions in the Group Permissions area. For example, Figure 9-4 shows the permissions granted to the New Data Users group.

    2. Select the check boxes for the groups you want to include in the security model.

    3. Click Next.

    4. The next Security Wizard dialog box, shown in Figure 9-5, allows you to assign some permissions to the Users group but strongly recommends against that. Choose No, The Users Group Should Not Have Any Permissions.

      Figure 9-5: The Security Wizard recommends not giving the Users group any permissions.
      Securing the Access Database

    5. Click Next.

    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 2 hosted by Hostway
    Stay green...Green IT