user permissions in access 2003

14 Mar 2007 8:05 PM

Todd

I've asked this question before but I apparently did something wrong. I've
got a secured dbase and one of the groups is called "Full Data Users". All
the users that will be entering, editing, deleting data are located here.
This works fine but I'd like to restrict each of them from accessing each
others information in the data entry form (where they enter, edit, delete
data).

Descripton of how I've got my dbase set up:

The dbase main menu page has 5 command buttons. Each button identifies a
region they can open to enter data on that regions vehicles. The command
button has a macro attached to open through a query that sorts for that
regions vehicles and then opens the form. The actual form is the same form
for all data entry, the different command buttons just sort for each specific
region.

How can I modify the users permissions to deny each of them access to the
others vehicle information? Do I need to take all the users out of the "Full
Data user" group and have them be just users?

Assistance is greatly needed!

--
Todd

15 Mar 2007 9:28 AM

Keith Wilby

Show quote Hide quote

"Todd" <t**@discussions.microsoft.com> wrote in message
news:AFE22C77-86FC-4B1D-843B-105E4000C390@microsoft.com...
> I've asked this question before but I apparently did something wrong.
> I've
> got a secured dbase and one of the groups is called "Full Data Users".
> All
> the users that will be entering, editing, deleting data are located here.
> This works fine but I'd like to restrict each of them from accessing each
> others information in the data entry form (where they enter, edit, delete
> data).
>
> Descripton of how I've got my dbase set up:
>
> The dbase main menu page has 5 command buttons. Each button identifies a
> region they can open to enter data on that regions vehicles. The command
> button has a macro attached to open through a query that sorts for that
> regions vehicles and then opens the form. The actual form is the same
> form
> for all data entry, the different command buttons just sort for each
> specific
> region.
>
> How can I modify the users permissions to deny each of them access to the
> others vehicle information? Do I need to take all the users out of the
> "Full
> Data user" group and have them be just users?
>

You need a way of associating the current username with the records, so you
will need a username field in the table with the appropriate username in
each record. You will also need to capture the username when the user
creates a new record. Assuming you have a text box on your form called
txtUserName which is bound to the username field, put this in the form's
Before Update event:

Me.txtUserName = CurrentUser

You can then do a simple comparison in the form's current event and set the
Allow Edits property accordingly.

If Me.txtUserName = CurrentUser Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If

You don't need to change permissions at all.

HTH - Keith.
www.keithwilby.com