Filters for linked table

[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 user will be unable to alter?

Thanks!

 

[Jeff Boyce]

Charles

What you describe may be possible via Access security (available in Access
2003, removed in Access 2007). Try the security newsgroup for ideas on how.

If your data were located on a SQL-Server, I came up with a mechanism for
implementing "row-level security" (users only see "their" rows), but it
wasn't particularly pretty... (and the SQL DBAs told me it couldn't be done
<g>).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Charles]

Thanks Jeff - I'll try security...
--
Charles

Charles

What you describe may be possible via Access security (available in Access
2003, removed in Access 2007). Try the security newsgroup for ideas on how.

If your data were located on a SQL-Server, I came up with a mechanism for
implementing "row-level security" (users only see "their" rows), but it
wasn't particularly pretty... (and the SQL DBAs told me it couldn't be done
<g>).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

One other possibility would be to use queries on the linked tables rather
than the tables themselves. This would only be an option if you are
distributing a proper front end database that only allows users access
through forms.
You could devise a way where the application would know the user's location
and use that to filter all data. Then distribute an mde file rather than an
mdb so there would be no way for them to change the filtering.