即使对于具有权限的用户，数据库也会锁 [英] Database locked even for users that have permission

问题描述

我有一个数据库.mdb是由不再在这里工作的人创建的。我的任务是为我们的需求创建一个新数据库，但我需要从旧数据库中检索一些信息。我和其他几个用户都有权限，但是没有人可以打开它。我们收到您没有权限的消息。即使我们应该这样做。有任何想法吗？？任何帮助表示赞赏。谢谢。

I have a database .mdb that was created by someone who no longer works here. I have been tasked with creating a new database for our needs, but I need to retrieve some info from the old database. I have permission as well as a couple of other users, however, no one is able to open it. We get the message that "you do not have permission" even though we supposedly do. Any ideas?? Any help is appreciated. Thanks.

推荐答案

如果是Windows权限问题，您应该能够右键单击该文件并选择属性，然后转到安全选项卡，看看是否或者您的组被列出。


如果是数据库中的权限问题，请在双击打开文件时按住Shift键。这将阻止任何宏（我也相信VBA代码）运行。你应该至少能够以这种方式进入数据库。

If it is a Windows permission problem, you should be able to right click on the file and select properties then go to the Security tab and see if you or your group are listed.

If it is a permissions problem within the database, then try holding the shift key when you double click to open the file. This will prevent any macros (and I believe VBA code as well) from running. You should at least be able to get into the database that way.

感谢您的回复。我实际上尝试了这两个并仍然得到相同的结果。具有Windows权限。我完全掌控，甚至可以取得所有权，但它仍然不会让我进去。我在打开时试图按住SHIFT并获得没有许可。消息。

Thanks for your reply. I have actually tried both of those and still get the same results. With the Windows permissions. I have full control and have even been able to take ownership, but it still will not let me in. I have tried holding SHIFT while opening and get the "do not have permission" message.

您能否向我们展示您收到的消息框的屏幕截图？可能有点简单，以确定它是自定义消息框还是Windows窗口。


您是否从最初所在的位置运行.mdb？如果没有，尝试在原始位置查找其他访问文件，特别是我认为它被称为mdw（它的文件访问创建调用用户级安全性，并与主数据库保持独立）。我自己从未使用它，这就是为什么我不记得正确的扩展名。如果数据库无法提交安全文件，您的问题听起来可能会发生。

Could you show us a screenshot of the messagebox you are receiving? Might be a bit simpler to determine if its a custom messagebox or a windows one.

Are you running the .mdb from the same location as it was originally located? If not, try to look in the original location for other access files, specifically I believe its called a mdw (Its a file access creates to invoke user level security, and is kept seperate from the main db). I have never used it myself, thats why I can''t remember the correct extension. Your problem does sound like something that might occur if the db cannot file the security file.

这篇关于即使对于具有权限的用户，数据库也会锁的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！