MS Access前端无法使用加密的后端打开 [英] MS Access Frontend won't Open with an Encrypted Backend

问题描述

我在MS Access(2016)中面临一个奇怪的问题.当我将数据库分为前端和后端并加密后端时，前端无法打开.

I'm facing a strange issue in MS Access (2016). When I split my database into a frontend and a backend, and encrypt the backend, my frontend fails to open.

在拆分数据库并加密后端后打开前端时，我应该看到链接表，该链接表只有在通过输入加密密码重新链接它们后才能打开.相反，我总是被带到Access的文件打开"菜单(图片)，就好像前端从未存在过一样！一旦我解密了后端，前端就会开始正常工作，并显示链接表.

As I open my frontend after splitting the database and encrypting the backend, I should see linked tables, which should not open until I relink them by entering the encryption password. Instead, I'm always taken to Access's 'file open' menu (Image), as if the frontend never existed! As soon as I decrypt the backend, the frontend starts working normally, displaying the linked tables.

我尝试拆分另一个从Internet下载的数据库，但未发生此问题.因此，我已经将该问题归结到我的数据库文件中.但是我没有开发背景，所以我不知道如何解决它，或者出了什么问题.

I tried splitting another database downloaded off the internet, and the issue did not occur. So I've singled the issue down to my database file. But I don't have a development background, so I have no idea how to fix it, or what could be going wrong.

数据库中有一些VBA代码，大部分是从Internet复制的.我尝试搜索类似的问题，但没有运气:(.

There is some VBA code in the database, which is mostly copied off the internet. I tried searching for a similar issue, but with no luck :(.

请帮助！

可以在此处下载数据库文件(FE，BE和未拆分).

The database files (FE, BE and unsplit) can be downloaded here.

推荐答案

我只是摆弄东西，我想我找到了解决此问题的答案.

I just fiddled around and I think I found the answer to solve this issue.

如果您使用该代码来阻止旁路移位键和单击鼠标来访问您的后端数据库，则以下步骤将帮助您解决此问题.

If you have used the code to block the bypass shift key and mouse click to get access to your backend database then the following steps will work for you to fix this issue.

转到未拆分的数据库，然后转到表视图.然后单击表格上方的所有访问对象"部分，然后单击导航选项"，然后在显示隐藏的对象"和显示系统对象"框中打勾.

Go to your unsplit database and and go to table view. Then click on All Access Objects Section above the tables and click on option NAVIGATION OPTIONS then tick the boxes "Show hidden objevts " and "Show System Objects"

现在返回表列表，尝试找到隐藏的表，该表包含阻止移位旁路键的代码，在我的情况下，我的表是冷的"UsysRibbons"，然后必须将其删除.

Now go back to your table list and try to find your hidden table that holds the code to block shift bypass key, in my case my table is cold "UsysRibbons" and then you have to delete it.

然后拆分您的数据库，即使您将后端数据库重定位到其他文件夹，您也可以打开您的前端数据库.

Then split your database and you will be able to open your front end database even if your back end database is relocated to other folder.

但是，如果您仍然想保留块移位旁路键功能，则必须转到未拆分的数据库，复制此"UsysRibbons"表，其中包含阻止块移位旁路代码的代码，并将其仅粘贴到拆分后端数据库上不会将其链接到您拆分后的前端，然后一切都会照常工作.

But if you still want to retain block shift bypass key functionality you have to go to your unsplit database copy this "UsysRibbons" table that holds the code to block shift bypass code and paste it to only to your split back end database don't link it to your split front end, and then everything will work as usual.

如果这不是为什么当后端重新定位到其他文件夹时为什么您不能输入前端的问题，那么您必须查看所有这些隐藏的系统表，并尝试将它们逐个删除以找出哪个表是导致问题的寄生虫表.

If this is not the issue why you can't enter your front end when back end is relocated to other folder then you have to look at all of those hidden system tables try to delete them one by one to figure out which table is the parasite table that causes problem.

祝以后遇到相同问题的每个人都好运.

Good luck to everyone in the future who encounters the same issue.

谢谢

这篇关于MS Access前端无法使用加密的后端打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！