Restrict Record Access By User

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

Guest

I downloaded MS Access Contact Management db for A2003 to use as a start in
developing an uncomplicated contacts db for our salespeople. Before I get
started, there is one feature that I would like to adjust in the forms as I
will have more than one employee who will be accessing the db from different
pc's.

Say I have two sales people, Jim and Tom. I want them both to be able too
see and view all potential customer contacts. As they scroll through the
list, Tom decides to call a customer and selects a pulldown box indicating
that he is now the "owner" of that customer. Although Jim can see this from
his pc, he cannot make any changes to Tom's record and vice versa. Anyone
have any ideas as to how this might be accomplished via forms without having
to get into user level security and all that other complicated access stuff?
 
presumably you have a table in your database that lists all users. if each
user logs into the network (not the Access database) with their own ID and
password, you can add a field to that table listing each user's ID (*not*
their password).

when a user attempts to edit a record that is "owned", you can use code to
retrieve that user's ID, and compare it to the ID of the record's "owner" as
stored in the users' table. if the IDs don't match, don't allow any changes.

you'll find the code to get the user ID at
http://www.mvps.org/access/api/api0008.htm

hth


MBoozer said:
I downloaded MS Access Contact Management db for A2003 to use as a start in
developing an uncomplicated contacts db for our salespeople. Before I get
started, there is one feature that I would like to adjust in the forms as I
will have more than one employee who will be accessing the db from different
pc's.

Say I have two sales people, Jim and Tom. I want them both to be able too
see and view all potential customer contacts. As they scroll through the
list, Tom decides to call a customer and selects a pulldown box indicating
that he is now the "owner" of that customer. Although Jim can see this from
his pc, he cannot make any changes to Tom's record and vice versa. Anyone
have any ideas as to how this might be accomplished via forms without having
to get into user level security and all that other complicated access
Click to expand...
stuff?
 
Back
Top