Re: How to make all access to linked table read-only
- From: "Wayne Morgan" <comprev_gothroughthenewsgroup@xxxxxxxxxxx>
- Date: Fri, 29 Jul 2005 03:17:47 GMT
To unhide it to see it again, go to Tools|Options|View tab and check the box
next to Hidden Objects. Don't hide the table using code, there is a bug that
can cause you problems.
--
Wayne Morgan
MS Access MVP
"Bob Alston" <tulsaalstonsNOSPAM@xxxxxxx> wrote in message
news:NKeGe.53577$4o.5708@xxxxxxxxxxxxx
> 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
.
- Follow-Ups:
- Re: How to make all access to linked table read-only
- From: Br@dley
- Re: How to make all access to linked table read-only
- Next by Date: Re: How to make all access to linked table read-only
- Next by thread: Re: How to make all access to linked table read-only
- Index(es):
Relevant Pages
|
