Access Security

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

Guest

I have recently set up some security on an existing database where each
person has there own Log in and User ID. What I am struggling to do at the
moment is that because each user belongs to a group I can't specify what each
user see.

Basically I only want each user to see information specifically about
themselves but I am unsure how to do this. Will I need to set each user up
with there own group and there own table to be able to do this?? I hope
not!!!! Can anyone help me????

Thanks in advance for your help.

Paul
 
Paul said:
I have recently set up some security on an existing database where
each person has there own Log in and User ID. What I am struggling
to do at the moment is that because each user belongs to a group I
can't specify what each user see.
Click to expand...

Well you can, if what they see depends on the group, rather than the user.
Basically I only want each user to see information specifically about
themselves but I am unsure how to do this. Will I need to set each
user up with there own group and there own table to be able to do
this?? I hope not!!!! Can anyone help me????
Click to expand...

You want to look at the CurrentUser() function. That returns the Access
login username for the user. You can add a field to your table(s) to hold
this information. In all your forms you can use the function to set this
field to the current user's name. You can also use the function as criteria
in a query to restrict records to just that user's.
 
Joan ,

Would this function work if multiple people were accessing the database at
anyone time?? Or would I have to put a copy of the database on everyones
computer?

Have many user can you have per group in access?
 
Paul said:
Joan ,

Would this function work if multiple people were accessing the
database at anyone time??
Click to expand...

Yes it would work.
Or would I have to put a copy of the
database on everyones computer?
Click to expand...

You should split the database into frontend (all objects except the tables)
and backend (just the tables/relationships). Put the backend on the server
along with the workgroup file. The frontend contains linked tables - linked
to the backend. Give a copy of the frontend to each user on their PC.
Have many user can you have per group in access?
Click to expand...

There is a limit of 255 users total per mdw (I'm not aware of a limit per
group).
 
Back
Top