G
Guy Kerr
This is probably a stupid/simple question but one I've never taken the time
to figure out.
I have an Access ADP front-end which uses views as the source to its forms.
I have a field in my CLIENT table that I want query in my view but I don't
necessarily want to give my users the ability to update the client table.
Currently the CLIENT table is NOT part of my view.
So my form (based on the view) allows my users to insert and update records.
But I want to add a criteria to the view that says where CLIENT.DIALER =
'TRUE' so I need to join the CLIENT table to my existing view. But currently
my users don't have INSERT or UPDATE abilities on the CLIENT table. If I try
to just add the where CLIENT.DIALER = 'TRUE' (and the join to my CLIENT
table of course) without changing the INSERT/UPDATE permissions on the CLIENT
table then the entire view becomes READ ONLY. The only way I could figure
out how to fix this is to give my users INSERT/UPDATE permissions on the
CLIENT table. Is there a way to query the client table for DIALER= 'TRUE'
without having to either add the table to my view or modify the permissions
and expose the CLIENT table?
Thanks in advance
Guy
to figure out.
I have an Access ADP front-end which uses views as the source to its forms.
I have a field in my CLIENT table that I want query in my view but I don't
necessarily want to give my users the ability to update the client table.
Currently the CLIENT table is NOT part of my view.
So my form (based on the view) allows my users to insert and update records.
But I want to add a criteria to the view that says where CLIENT.DIALER =
'TRUE' so I need to join the CLIENT table to my existing view. But currently
my users don't have INSERT or UPDATE abilities on the CLIENT table. If I try
to just add the where CLIENT.DIALER = 'TRUE' (and the join to my CLIENT
table of course) without changing the INSERT/UPDATE permissions on the CLIENT
table then the entire view becomes READ ONLY. The only way I could figure
out how to fix this is to give my users INSERT/UPDATE permissions on the
CLIENT table. Is there a way to query the client table for DIALER= 'TRUE'
without having to either add the table to my view or modify the permissions
and expose the CLIENT table?
Thanks in advance
Guy