Re: How to make all access to linked table read-only

Wayne Morgan wrote:
While this won't stop them if they get access to the database window, you could make the queries "Snapshots". Snapshots are read only and any subsequent object based on that query will also be read only for data that comes from that query. Also, reports aren't a problem, there is no editing data that the user can do in a report. The problem would come it if you give them access to a form or query (or the table itself) that is read/write.

GREAT.

In the interim read about a way to relate the table to a table in a read-only db and use the resultant query.

Your's is cleaner. And I understand I can hide the linked table entry (but not sure how to unhide it to see it again).

Bob
.

Relevant Pages

  • Re: How to make all access to linked table read-only
    ... could make the queries "Snapshots". ... comes from that query. ... Also, reports aren't a problem, there is no editing ...
    (comp.databases.ms-access)
  • Re: How to make all access to linked table read-only
    ... Bob Alston wrote: ... Snapshots are read only and any subsequent object based on that query will also be read only for data that comes from that query. ... Also, reports aren't a problem, there is no editing data that the user can do in a report. ...
    (comp.databases.ms-access)
  • Re: How to make all access to linked table read-only
    ... Bob Alston wrote: ... Snapshots are read only and any subsequent object based on that query will also be read only for data that comes from that query. ... Also, reports aren't a problem, there is no editing data that the user can do in a report. ...
    (comp.databases.ms-access)
  • Re: Newbie? Do I use Report or Query
    ... <<what I really want is a conceptual model of how forms, queries and reports ... Reports are the counterpart of Forms. ... If based on a query, ... JobCard and JobDetails tables showing the fields in each for further ...
    (microsoft.public.access.gettingstarted)
  • Re: Newbie? Do I use Report or Query
    ... Makes reading your database easier! ... Table JobDetails ... Reports are the counterpart of Forms. ... If based on a query, ...
    (microsoft.public.access.gettingstarted)