Yes, you can do this using Run With Owner Permission (RWOP) queries. For
example, you could set this up so that user 'A' would not be able, by any
method, under any circumstances, to see the data entered by user 'B'. This
would require a full implementation of so-called user level security.
However, that is often overkill. An easier & simpler method is to do it
through VBA code. Define a field in each table, to hold the username of the
user who created that record. Code the BeforeUpdate event of each form, to
put the value of the CurrentUser() function into that field. Now each record
knows who created that record. Then base each form on a query like:
SELECT * FROM MyTable WHERE CreatedBy = CurrentUser()
where CreatedBy is the new field. Then, each form would only show the
records that were created by the current user.
You would need to create some new users in your Workgroup file, & assign a
password to the Admin user. Then, each user would have to log-on with their
username, & Currentser() would return that name. You would not need to do
any of the other 50 gazillion things that are normally needed for user level
security.
HTH,
TC
Leonard said:
Is it possible to apply record level security for multiple users of a table?
In other words, I only want certain records to be viewed by certain users
of a particular table.
