user-level security

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
 
R

Rick B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User level security 3
Access 2003 allowing users to view only certain records 6
Excel Excel conundrum - I've tried and tried, but 10
User Level Security 2
Establishing Record Level Security in Access 2000 1
Password setup showing hisotry of records changed 4
Using domain login names for access control? 3
Problem adding group to user-level security 3

Top