Access 2010允许多个用户/实施组安全 [英] Access 2010 allowing multiple users/ Implementing group security

问题描述

我正在创建一个Access 2010数据库，并希望在并发性和安全性方面进行一些说明.我想要的是在启动应用程序时仅显示一个菜单窗体，其中包含几个按钮，包括登录按钮.大多数按钮将被禁用，直到用户登录后才根据其权限组进行；查看器(默认)，工作人员，编辑者，管理员.

I'm creating an Access 2010 database and would like some clarification when it comes to concurrency and security. What I would like is upon starting the app only a menu form to be displayed with several buttons including a login button. Most buttons would be disabled until after the user logs in at which point based on their permission group; Viewer(Deafault), Worker, Editor, Admin.

此外，管理员应该是唯一能够看到访问数据库的人，而其他人只能看到表格.

Also, Admin should be the only one to be able to see the access database while the others are restricted to seeing the forms only.

我只是在测试默认的并发实现，但是将数据库保存到共享的网络中，并让自己和同事尝试访问它.发现一个人是否访问了数据库，将其与其他人锁定了，如果我们都尝试同时访问该数据库，则该数据库变为只读状态.

I was just testing the default concurrency implementation but saving my database to a shared network and having myself and a co-worker try to access it. Found out if one accessed the database it locked it from others, and if we both tried at the same time it became read-only.

所以我只是在寻找有关如何启动它的提示.

So I'm just looking for tips on how to start this.

推荐答案

对于Access数据库，所有用户必须至少具有对数据库所在文件夹的读取，写入和修改权限.这是因为MS Access创建了一个锁定文件，并且如果第二个用户没有修改锁定文件的权限，则该用户将无法访问数据库.删除权限可能也很有用，可以在最后一个出现的人时删除锁定文件.

For an Access database all users must have as a minimum read, write and modify permissions on the folder in which the database resides. This is because MS Access creates a lock file and if the second user does not have permissions to modify the lock file, the cannot get access to the database. Delete permissions may also be useful, to remove the lockfile when they are the last person out.

这篇关于Access 2010允许多个用户/实施组安全的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！