共享受用户影响的单个mdb文件的属性 [英] Sharing properties of a single mdb file affected by user

问题描述

各位大家好！


我刚刚发现3个用户访问的单个数据库（网络上的mdb文件）的共享属性会根据用户访问权限而变化数据库。也就是说，在2个用户同时打开文件的情况下，在我的计算机中，共享属性显示为设置为共享（非独占）和单个入口锁定。然而，在其他用户的计算机中，共享属性被设置为独占模式和全条目锁定。为什么，使用单个文件（既不分割也不使用链接表和不同文件），共享模式会根据用户而变化？更糟糕的是，即使有2个用户同时打开数据库，共享属性也会有所不同？ Access试图愚弄我们吗？


来自巴塞罗那的最佳问候

解决方案

嗨。我怀疑有问题的用户没有对数据库所在的共享目录的创建权限。作为MS知识库文章，此处链接指出，如果共享无法创建.ldb锁定文件，该用户将以独占模式打开数据库。


放置在共享目录中的Access数据库的每个用户所需的用户权限为Read，写，编辑，创建和删除。


-Stewart

再次嗨。我现在关闭了你在4月3日开始讨论这个主题的上一个主题。如果您没有收到第一篇帖子的回复，那么创建重复的主题并不是一个好习惯。所有你需要做的就是通过回复你自己的问题来突破这个主题，询问你的问题是否可以让你的问题重新审视。


-Stewart

Hi Stewart：


首先：对于因第二篇帖子造成的任何不便，请为此深表歉意。我再次写了这篇文章以便提供新的信息。

其次，我不知道你评论的是de tools> security> group和users permission。是吗？


提前谢谢


祝你好运

Hello everybody!

I have just found out that the sharing properties of a single database (mdb file on a network), accessed by 3 users, change depending on the user accessing the database. That is, with the file opened by 2 users at the same time, in my computer, the sharing properties appeared as set to share (not exclusive) and single entry-lock. Nevertheless, in the computer of the other user, the sharing properties are set to exclusive mode and an all-entries lock. Why, with a single file (neither splitted nor working with linked tables and different files), the Sharing mode change depending of the user? And what is worse, why the sharing properties differ even with 2 users having the database opened at the same time? Is Access trying to make a fool of us??

Best regards from Barcelona

解决方案

Hi. I suspect that the user in question does not have Create rights to the shared directory in which the database is located. As an MS Knowledgebase article linked here states, if the shared .ldb lock file cannot be created the database will be opened in exclusive mode by that user.

The user rights required for each user of an Access database placed in a shared directory are Read, Write, Edit, Create and Delete.

-Stewart

Hi again. I have now closed the previous thread which you started on this topic on 3 April. It is not good practice to create duplicate threads if you don''t get a reply to your first post. All you need to do is to ''bump'' the topic by posting a reply to your own question asking if a contributor could look again at your issue.

-Stewart

Hi Stewart:

First and foremost: let me apologise for any inconveniences caused by this second post. I wrote it again so as to provide new information.
Second, I don''t know if what you''re commenting is de tools>security>group and users permission. Is that it?

Thank you in advance

Best regards

这篇关于共享受用户影响的单个mdb文件的属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！