如何使对链表的所有访问权限都是只读的 [英] How to make all access to linked table read-only

问题描述

任何人都知道一种方法可以对所有链接表进行访问，在另一个方面

访问MDB，只读？


我真的不喜欢想要实现完全访问安全性的所有麻烦。


我不能在服务器文件系统中这样做，因为在某些前端

用户需要更新访问权限。


我想让用户使用他们自己的

查询和报告来访问报告数据。我只是不想冒险给他们

通过这些工具更新数据。


Bob

解决方案

虽然如果他们可以访问数据库窗口就不会阻止他们，你可以使用b $ b来查询Snapshots。快照是只读的，任何基于该查询的
后续对象也将只读取来自该查询的数据。此外，报告不是问题，用户可以在报告中进行编辑

数据。如果你给

他们访问一个可读/写的表单或查询（或表本身），问题就会出现。


-

Wayne Morgan

MS Access MVP

" Bob Alston" <涂**************** @ cox.net>在消息中写道

新闻：W％dGe.53575

4o.43523@fed1read06 ...

任何人都知道如何让所有访问链接表，在另一个Access
MDB，只读？

我真的不想要实现完全访问安全的所有麻烦。
用户需要更新访问权限。

我想让用户访问数据以进行报告拥有
查询和报告。我只是不想抓住机会通过这些工具更新数据。

Bob

< blockquote> Wayne Morgan写道：

虽然如果他们可以访问数据库窗口就不会阻止他们，你可以查询Snapshots。快照是只读的，基于该查询的任何后续对象也将只读取来自该查询的数据。此外，报告不是问题，用户可以在报告中执行编辑数据。如果你让他们访问一个可读/写的表单或查询（或表本身），就会出现问题。

GREAT。


在临时读物中有关将表与

只读数据库中的表关联的方法，并使用生成的查询。


你的'更干净。而且我知道我可以隐藏链接表条目

（但不知道如何取消隐藏它再看一遍）。


Bob

Anyone know a way to make all access to a linked table, in another
Access MDB, read only?

I really don''t want all the hassle of implementing full access security.

I can''t do this at the server file system because in some front ends the
user needs update access.

I want to give users access to the data for reporting with their own
queries and reports. I just don''t want to take a chance on them
updating the data via such tools.

Bob

解决方案

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.

--
Wayne Morgan
MS Access MVP
"Bob Alston" <tu****************@cox.net> wrote in message
news:W%dGe.53575

4o.43523@fed1read06...

Anyone know a way to make all access to a linked table, in another Access
MDB, read only?

I really don''t want all the hassle of implementing full access security.

I can''t do this at the server file system because in some front ends the
user needs update access.

I want to give users access to the data for reporting with their own
queries and reports. I just don''t want to take a chance on them updating
the data via such tools.

Bob

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

这篇关于如何使对链表的所有访问权限都是只读的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！