I am working with Access 97 which will be upgraded to XP possibly as soon 
as next month sometime.  In the meantime, I am trying to set password 
security on a database for an I/T department.  Can someone recommend the 
best way to set up the security.  The database has personnel-related 
information.  I don't think anyone would try to view others information 
but the plan is for it to be as secure as possible.  

Hi Mikki,

You have two main choices: Share-level security and User-level
security.

Share-level security is simple and quick. You just set a password for
the whole database that all authorized users share. Unauthorized folks
can?t get in (until one of the authorized folks gets lazy and gives
out the password), and anyone who does get in has full access to all
the database objects. For most business environments, and where
sensitive information is an issue, share-level security doesn?t
cut it. See the Help file for setting a Share-level password.

User-level security is what you should probably be looking at, because
it allows you to grant specific permissions to users and groups in a
workgroup.  The user and group security information is stored in a
workgroup information file (default name System.mdw) that is stored
external to your app. When a user logs on with their own password,
Access goes out and reads the workgroup information file to see what
permissions have been granted to that user.

The easiest way to implement user-level security is to use the User
-Level Security Wizard. The wizard automatically creates a .mdw file
and implements some common security schemes. In Access 2000 and 2002,
the wizard handles everything for you; in Access 97, there are a few
steps you need to take before and after using it. The wizard
also lets you secure your database objects without requiring users to
log on, if you don?t really need to grant permissions to various
groups of users.

Check out 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrrunninguserlevelsecuritywizard.asp 
for more info.

Best,

Bob

>From: Mikki.Maxwell@a...
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Password security
>Date: Tue, 22 Oct 2002 23:01:16
>
>I am working with Access 97 which will be upgraded to XP possibly as soon
>as next month sometime.  In the meantime, I am trying to set password
>security on a database for an I/T department.  Can someone recommend the
>best way to set up the security.  The database has personnel-related
>information.  I don't think anyone would try to view others information
>but the plan is for it to be as secure as possible.


_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband.  
http://resourcecenter.msn.com/access/plans/freeactivation.asp