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