About providing user-level security on a specific Microsoft Access database

When users join a Microsoft Access workgroup by using the Workgroup Administrator, the location of the workgroup information file is stored in the Windows Registry, which means that in many cases all Access databases on the user's machine will use user-level security based on that workgroup information file.

However, you may want to use user-level security on a specific database, and not use it on others. To do this, don't have users join a Microsoft Access workgroup by using the Workgroup Administrator. Instead, take the following steps:

1. Create a workgroup information file and store it in a location that is accessible to all users of that specific database.
   
   
2. Create a shortcut that starts the specific database by using the /wrkgrp command-line option to specify the location of the workgroup information file. For example:

   "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE \\SalesSystem\DBFiles\SalesS.mdb /wrkgrp \\SalesSystem\DBFiles\SalesS.mdw"

   For more information on creating shortcuts, see Windows Help.