Q: How can I hide fields depending on the user?

  • Thread starter Thread starter A C
  • Start date Start date
A

A C

Hi

Is there a way to hide fields depending on the user in table or query view,
*not* using forms.
So for example
User1 logs on, opens the myStuff table and sees all the fields. User 1
opens myQuery on myStuff (which simply returns the contents of myStuff) then
user1 sees all the fields.
User 2 logs on, opens the myStuff table and sees only 5 fields. User 2
opens myQuery on myStuff and still only sees 5 fields.

Thanks in advance
A
 
Not AFAIK. The users should not access the DatasheetView
of the Tables (or Queroes)directly in properly-developed
Access database applications, anyway. The reason is that
you have no control on what the user going to do with the
data (unlike using Forms as the user interface).

For Queries, you can create different Queries showing
different Columns but then it get messy as you need a
number of different Queries.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top