Link to query and not table

[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

 

[Patrice]

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...

 

[Jacques]

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?

 

[Patrice]

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...

 

[Jacques]

Thank you Patrice,
You've been a big help.

Jacques

 

[Patrice]

Not really how I feel but thanks ;-)

Thank you Patrice,
You've been a big help.

Jacques