user-level security

  • Thread starter Thread starter BillT
  • Start date Start date
B

BillT

Hi: Access 2000

A couple of questions:

1. How do I link a user's log credentials to a
table/query. I want to be able to match their log in ID
which is their employee id with their corresponding names
in a table or query?

2. I also want to be able to track their activities while
they are in the database. Does MSAccess create a log to
record these changes?

Thanks
Bill
 
To use their login and compare it to table entries, you'd use the
CurrentUser() function.

To log their activities, you'd have to create code. This could be as simple
or as complex as you need.

Access does not trach user activity in any way.

Rick B


Hi: Access 2000

A couple of questions:

1. How do I link a user's log credentials to a
table/query. I want to be able to match their log in ID
which is their employee id with their corresponding names
in a table or query?

2. I also want to be able to track their activities while
they are in the database. Does MSAccess create a log to
record these changes?

Thanks
Bill
 
Back
Top