log into db with windows login/password

B

bora

I think this is different than setting permissions and
passwords for users and groups. Please offer a solution
since I'm stuck.
I'm trying to have salesreps login to the database with a
login/password. The database is a list of potential
customers they will call and each salesrep is assigned a
certain number of leads. So when a salesrep logs in with
his/her user name and password (windows login/password or
another one I can create) I want them to access only the
records that are assigned to that salesrep. So if there
are 1,000 records in the db, and there are 10 salesrep,
each salesrep gets 100 leads assigned to him/her and when
they open the database they would only be able to see the
records that are assigned to them. After they login I
need to have salesreps open the main FORM which is called
Contacts and be able to select from a list of ;
1) Open
2) Pending
or
3) Closed contacts

Thanks for sharing the knowledge.
 
V

Van T. Dinh

There are a number of different ways you can do it

1. Implement Access Security. In this case, the Sales
Rep will have to log on to the database (on top of logging
on to your network). In this case, you can use the built-
in function CurrentUser() to retrieve the (Access)
UserName.

2. Use the code from The Access Web

<http://www.mvps.org/access/api/api0008.htm>

to identify the user network LogOnID.

Either way, you will need to maintain a "Users" Table in
Access and assign leads according to this Table.

HTH
Van T. Dinh
MVP (Access)
 
Top