RE: How to restrict users to see data in a mutiuser environment?

What is the best practice in this situation? Should I use Workgroup security
or should I use some other approach? What would be any other approach? I
hope I am not asking too much? Since I am a novice Access user, please don't
be annoyed. Thanks.
--
thadi


"Klatuu" wrote:

The code I posted will show only the selected department when the form is
opened.

If you plan to use workgroup security, you could assign users to groups by
department, then set the filter based on the group of the user that is the
current user.

"Tasmania" wrote:

Thanks.
My combo is a text field and it works fine with the filtering. Thanks fir
the code.
Now how would I set up the security? If a time keeper logs in how would I
restrict them to see their specific dept data?
Thanks in advance for the response.
--
thadi


"Klatuu" wrote:

You would need to have the combo with all the departments on the form from
which you open the form you want to filter. Then when you open the form
Docmd.OpenForm "MyForm", , ,"[Department] = '" & Me.cboDepartment & "'"
The above is if the Department field in your table is a text field. If it
is numeric:
Docmd.OpenForm "MyForm", , ,"[Department] = " & Me.cboDepartment

"Tasmania" wrote:

Thanks alot for the response.
For the first part, I am using a combobox on the mainform where the user
will select the dept and it will take them to the data entry form for that
department only.

For the second part, I would like use Access Security where each timekeeper
will have a username and password with the WorkGroupInformationFile.
When database opens up, the user need to put in the userid/password, and
then it will take them to the mainform. In the mainform they will select
their department, and so on. How do I do that? Thanks again


--
thadi


"Klatuu" wrote:

First, the easy part.
Filter the form by department number so only that department's employees
will be included.

Now the hard part. That is, to know which department should be included.
Since I don't know enought about your applicatioin, I don't know if you are
using security or if you have any way of knowing who the user is and what
that user's deparment is. This is the part you will have to determine. The
question is "How do I know which department to filter on?"

If you can define how you will know that, I will be happy to help with the
coding of it.

"Tasmania" wrote:

I have a timekeeper database where one timekeeper from each department will
keep their own employee time. I need to restrict the view of data for each
department so each deprtment can see only their own peoples data. How can I
do that? At this point I am clueless since I am a novice Access User.
I appreciate all the replies.
--
thadi
.

Relevant Pages

  • RE: How to restrict users to see data in a mutiuser environment?
    ... If you plan to use workgroup security, you could assign users to groups by ... Now how would I set up the security? ... which you open the form you want to filter. ... I am using a combobox on the mainform where the user ...
    (microsoft.public.access.modulesdaovba)
  • [NT] Vulnerability in Microsoft Internet Security and Acceleration Server 2000 H.323 Filter Could Al
    ... Get your security news from a reliable source. ... A security vulnerability exists in the H.323 filter for Microsoft Internet ... Security and Acceleration Server 2000 that could allow an attacker to ... overflow a buffer in the Microsoft Firewall Service in Microsoft Internet ...
    (Securiteam)
  • RE: How to restrict users to see data in a mutiuser environment?
    ... interested setting up workgroup security. ... ' Gets the userid of the current user. ... Dim Length As Long ... which you open the form you want to filter. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do I really need a FW besides WXP
    ... Controlling aleady running programs what ... > Since XP Home doesn't really have good security like XP Pro ... If the "router" is running a packet filter and maybe NAT, ... data security to filter away to hide something. ...
    (comp.security.firewalls)
  • Re: Do I really need a FW besides WXP
    ... Controlling aleady running programs what ... > Since XP Home doesn't really have good security like XP Pro ... If the "router" is running a packet filter and maybe NAT, ... data security to filter away to hide something. ...
    (comp.security.firewalls)