How to set up security on a Network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have no clue how to do this at all - here's what I'm trying to accomplish -

I need to set up levels of security for multiple people over a network.

Each person will access their own form and report but will not be able to
access any others. (i.e. they click on their name on the switchboard and I
want them to be prompted for a user name and password to open that particular
form or report).

Sounds simple enough but I'm clueless. So far the help I've been receiving
with this database has been great in this forum!! So kudo's to all that have
helped me!!

Deb.
 
Hi Debbie,

You'll need to implement User level security. There is a lot to it, so
study up and practice on a copy of your database until you're confident.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

You won't want to have users repeatedly entering their username/password for
each form/report. Rather have them login once to the database (on open),
and then you can limit what they see based on their username or based on the
security groups they are members of.

Study up on the resources and come back with specifc questions.
 
I have a similar issue - I need to stop users seeing data they're not
supposed to. However, this isn't based around certain forms or queries.
Ideally, they can access the records the create but not those created by
others. Of course, there needs to be an admin setting which allows editing of
all information.

Can any of you kind people help me?

Many thanks,

Matt L
 
You'll need to add a field to each of your tables identifying who 'owns' it.

In all your forms add a control bound to this field. Set it's default
property to
=CurrentUser()

That will store their Access username in the field - good for new records.

You'll need to update existing records manually, or by an update query.

All your forms need to be based on queries that include the owner field.
Set the criteria for the field to
=CurrentUser() and they'll only see 'their' records.

As for the administrator, in the open event for the form you can check if
the user is a member of the administrator group and if so change the record
source to SELECT * from table

All of this assumes that you implement User Level Security
 
Back
Top