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

Chapter 12. Managing a Database > Securing a Database

Securing a Database

As long as you are the only one working with a database, security issues are not usually a big concern. However, in a multi-user environment, you will probably need to consider how to secure the information your database contains. There are many threats to your data's integrity. It needs to be protected from users accidentally deleting important records or reports. Some parts of your database, such as a table containing employee salaries and social security numbers, will need to be restricted to a select group of users. You may even need to devise ways to protect your database from being hacked by someone using special programs designed to view your most sensitive data. Access security features help you ensure that your data will be secure under almost all circumstances.

Creating and Using Workgroups

A workgroup is a group of users in a multi-user environment who share data. A company's workgroup might consist of all of its employees, and to a certain extent, its customers and shareholders. Access stores workgroup information in a special file called the workgroup information file, also known as the system database. Access created a default workgroup information file during its initial setup. The information is typically stored in the System.mdw file located in the C:\Windows\System folder. You have been using this workgroup file since the first day you started Access, even if you weren't aware of it.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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