如何控制用户对 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屋！