• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

10. Multiuser Applications > 10.1. Properly Secure Your Database

10.1. Properly Secure Your Database

Problem

The database you’ve developed contains sensitive data to which you wish to limit access. You’d like to be able to create different classes of users so that some users have no access to this data, others can read the data but can’t change it, and still others can modify the data. At the same time, you don’t want to secure every object in the database this way; you’d like to apply security only to selected objects. Is this possible with Access?

Solution

Access supports two forms of security: workgroup-based security and database-password security. If you use the simpler database-password security system, you can assign only a single password to the entire database, which is inadequate for your purposes. Fortunately, your needs can be met by using the more sophisticated workgroup-based security system. However, securing a database this way can be tricky. This solution guides you through the process, starting with a completely unsecured database and finishing with a well-secured database that should meet your needs.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint