Filters for linked table

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

We have several remote users accessing a back-end database in Access 2003.
We need for their linked tables to only be capable of displaying data that
relates to their site. Is it possible to set up a filter on a linked table
that the common user will be unable to alter?

Thanks!
 
You are better off creating a query for them instead. You can implement security, and deny permissions to the tables; give them read data permission on the query (and save it as a RWOP query).

--
Joan Wild
Microsoft Access MVP
: We have several remote users accessing a back-end database in Access 2003.
: We need for their linked tables to only be capable of displaying data that
: relates to their site. Is it possible to set up a filter on a linked table
: that the common user will be unable to alter?
:
: Thanks!
:
: --
: Charles
 
Sorry, 'run with owner permissions' See www.jmwild.com/RWOP.htm for an explanation.

--
Joan Wild
Microsoft Access MVP
: Sorry not familiar with the acronym RWOP. What does it mean?
:
: Thanks!
:
: --
: Charles
:
:
: "Joan Wild" wrote:
:
: > You are better off creating a query for them instead. You can implement security, and deny permissions to the tables; give them read data permission on the query (and save it as a RWOP query).
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : We have several remote users accessing a back-end database in Access 2003.
: > : We need for their linked tables to only be capable of displaying data that
: > : relates to their site. Is it possible to set up a filter on a linked table
: > : that the common user will be unable to alter?
: > :
: > : Thanks!
: > :
: > : --
: > : Charles
: >
 
With SQL server, you can use 'ServerFilter' which would do _JUST_ like
what you want.
You could say .ServerFilter = "Location = 12" and you would only ever
be able to see Location = 12 records.

Works like a charm!!
 
Back
Top