user permissions in access 2003

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

Guest

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 said:
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?
Click to expand...

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
 
Back
Top