使用安全工作组访问卡住 [英] Access Stuck Using Security Workgroup

问题描述

我的老板幻想自己是IT天才，并创建了许多数据库，所有数据库都由Access的用户级安全MDW功能保护.现在，要使MDW功能起作用，您要么必须设计指向MDW的快捷方式，要么必须配置工作站以将MDW用作默认值.

My boss fancies himself an IT genius, and has created a number of databases, all secured with Access' user-level security MDW feature. Now for the MDW feature to work, you either have to craft shortcuts that point to the MDW, or you have to configure the workstation to use that MDW as default.

他选择了后者.

现在，当打开我的不安全数据库时，甚至试图创建新的空白数据库时，它都希望我登录到他的MDW.这受不了.

Now, when opening MY unsecured DBs, or even trying to create new blank ones, it wants me to login to his MDW. This cannot stand.

如何重新配置​​Access以使用默认的MDW(我认为它称为System.MDW).

How can I reconfigure Access to use the default MDW (I think it is called System.MDW).

NB:我无法在VB窗口中运行代码.我根本无法打开任何数据库.解决方案可能必须在Access外部.

NB: I cannot run code in the VB window. I cannot open any databases at all. Solutions must likely be external to Access.

推荐答案

好吧，事实证明，您需要将值HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Access Connectivity Engine\Engines\SystemDB修改为％appdata％\ Microsoft \ Access \ System.mdw"

Okay, as it turns out, you need to modify the value HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Access Connectivity Engine\Engines\SystemDB to "%appdata%\Microsoft\Access\System.mdw"

或者，对于Office 2010，为HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Access Connectivity Engine\Engines\SystemDB

Or, in the case of Office 2010, HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Access Connectivity Engine\Engines\SystemDB

不确定为什么我不首先在注册表中查看.

Not sure why I didn't look in the registry first.

这篇关于使用安全工作组访问卡住的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！