How to make some tables viewable to selected users

  • Thread starter Thread starter Tejas
  • Start date Start date
T

Tejas

Hi,
I was trying to use user and group security option in
Access which doesn't show how to make tables personalise
depending on different user.
That is i need some table to be view by few user and
other users cann't see all the tables.
Thanks for your help,
Bye.
 
I was trying to use user and group security option in
Access which doesn't show how to make tables personalise
depending on different user.
That is i need some table to be view by few user and
other users cann't see all the tables.
Click to expand...

You add and remove permissions from the particular tables for each group
and/ or user -- for your sanity's sake, stick mainly to user roles.

So for the Finance, you can grant Read and Write permission to the
BankAccount table; but for Managers you grant only Read; and nobody else
gets any permissions at all. And so on.

HTH


Tim F
 
Back
Top