Re: How to make all access to linked table read-only
- From: "Br@dley" <n0mail@xxxxxx>
- Date: Sun, 31 Jul 2005 23:23:04 GMT
Wayne Morgan <comprev_gothroughthenewsgroup@xxxxxxxxxxx> wrote:
> 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.
Ever tried hiding them in code? I think you can nly unhide them via code
which is sometimes useful. (I haven't done it myself though).
> "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
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response
.
- Follow-Ups:
- Re: How to make all access to linked table read-only
- From: Wayne Morgan
- Re: How to make all access to linked table read-only
- References:
- Re: How to make all access to linked table read-only
- From: Wayne Morgan
- Re: How to make all access to linked table read-only
- Prev by Date: SQL error "Arguments are of the wrong type ..."
- Next by Date: Rolling Average Calculation Problem
- Previous by thread: 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
|
|
