如何控制用户对 Access 数据库的权限? [英] How to control user rights to an Access database?
问题描述
允许一个用户对本地网络上的 MS Access 数据库进行写访问而其他所有人只读访问的最简单方法是什么?
What is the simplest way to allow one user write access and everyone else read-only access to a MS Access database on a local network?
我信任我的用户,但不幸的是,一旦取消选择表的行,Access 就会保存对数据的更改.无需用户要求保存更改即可保存意外击键.
I trust my users, but unfortunately Access saves changes to data as soon as the row of a table is deselected. Accidental keystrokes are saved without the user asking for the changes to be saved.
推荐答案
最简单的方法是使用共享权限.授予对组的写访问权限,并将必须写入数据库的用户放在该组中.把其他人放在一个阅读组中.当然,这假设您有一个 Windows 域.
The easiest way would be to use share permissions. Grant write access to a group and put the users who must write to the database in that group. Put everyone else in a read group. This assumes you have a Windows domain, of course.
此处是一个站点,其中包含一些有关保护 Access 数据库的信息.它涉及 Access 2000,可能有更多更新版本的选项.
Here is a site that has some information on securing Access databases. It deals with Access 2000, there may be more options for newer versions.
这篇关于如何控制用户对 Access 数据库的权限?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!