Re: Make linked tables read only?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Carl Rapson" <cr@xxxxxxxxxxx> wrote in
news:uB4wdZbcFHA.3204@xxxxxxxxxxxxxxxxxxxx:

> "Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
> news:eFD46HacFHA.2756@xxxxxxxxxxxxxxxxxxxxxxx

>>> The problem is, I don't want them making changes to
>>> the data or to the back-end data tables. So, is it possible to
>>> somehow link the data tables as "read only"?
>>
>> You can accomplish this by implementing security and giving minimal
>> permissions on the tables.
>>
> Thanks, Joan. I'll look through the information om your web site and
> see if it fits my needs.
>

Just to add an easier method:- you could show your users MS Query. This
is part of the default Office install (look for MSQuery32.exe) but there
is no shortcut created unless you make one yourself. Although it's
possible to write data-altering queries with it, it's not easy and
someone with that expertise can probably do it just as easily using Excel
or VB on their own. Basically, you get a full graphical query designer
with no work on your part!

You can combine the two if you like, with user level security protecting
the data and Query providing the user interface.

Hope that helps


Tim F

.

Relevant Pages

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: Search for accounts based on advanced security permissions
    ... to query the security attributes and to change permissions and security ... Search for accounts based on advanced security permissions ... don't think there is any easy way to query for all users. ...
    (microsoft.public.windows.server.active_directory)
  • RE: Permissions causing error on export?
    ... The Access security permissions might limit a user if they con't have ... I assume they can run the query fine within Access? ... Do MDW security settings affect VBA programming in using export/import ...
    (microsoft.public.access.security)
  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)