Link to query and not table

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

Is it possible to have an Access linked table, link to a SQL query, instead
of directly to a SQL table?
This way, I can securely filter the data without a lot of heavy coding.

Thanks beforehand,

Jacques
 
Yes, what have you tried that doesn't work ?

Also note that is the ADP group (i.e. Access uses directly the SQL Server
database so the concept of a linked table doesn't apply).

Try perhaps another group such as microsoft.public.access.odbcclientsvr...
 
My apologies if this is the wrong group.

My goal is to have multiple divisions of a company in the same database
showing personnel.

I want to set permissions where no one can access a table directly (as the
table would have everyone's unfiltered records and fields).
I want them to use the store procedures or queries as table sources.

My understanding is that SQL allows you to deny a person/group access to a
table, while giving them access to the data through a query or stored
procedure (giving them a dedicated filtered view).

Is this correct?
 
Correct. If this is a new application you may want also to check if an ADP
projet wouldn't fit.

I would suggest to create a proof of concept and come back for particular
questions...
 
Back
Top