
February 5th, 2010, 03:44 PM
|
 |
Contributing User
|
|
Join Date: Jan 2007
Location: Northern California
|
|
The default workgroup information file is "system.mdw", but you can have other such files, named anything you want (although that could become confusing). The 2 ways they can be used are: - Use the Workgroup Administrator feature (under Tools - Security) to "join" a workgroup by specifying the .mdw file to use. This would be done when an organization wants ALL their Access databases to be governed by the same workgroup permissions. In this case, you don't need to use a shortcut. Every time you open Access on that workstation, it will load that .mdw file.
- Create a shortcut or simply use the Run command line to tell Access to use a particular .mdw file for the specific operation with a specific database. This is done when you want to let users work with other databases that are not governed by one common .mdw file.
You will have to decide which of these approaches meets your organization's needs. If you use the second approach (using desktop shortcuts), you shouldn't need to worry about securing the front-end.
|