更改加密方法后连接到加密的Access数据库 [英] Connecting to an encrypted Access database after changing the Encryption Method

问题描述

基于从excel访问受密码保护的MS Access文件，我应该能够转到选项">客户端设置"，并将加密方法"设置为使用旧版加密"，然后能够通过Excel数据连接连接到我的加密数据库.但是，当我这样做时，仍然会反复提示我输入密码，最终不得不单击取消"(因此无法建立连接).

Based on Accessing Password Protected MS Access file from excel, I should be able to go to Options > Client Settings and set the Encryption Method to "Use Legacy Encryption" and then be able to connect to my encrypted database through Excel Data Connections. However, when I do this, I still get prompted for the password repeatedly and eventually have to hit Cancel (and thus get no connection).

我正在使用Excel 2010和Access2010.我的数据库已加密并具有链接表(以及许多查询，表单，报告，宏和VBA代码).

I am using Excel 2010 and Access 2010. My database is encrypted and has linked tables (as well as many queries, forms, reports, macros and VBA code).

有人可以帮我解决为什么这不起作用吗?

Can anyone help me solve why this isn't working?

推荐答案

在Microsoft Access设置中更改数据库的加密方法"设置不会自动使用新的加密方法重新加密文件.您必须先取消加密然后重新加密文件，新的加密方法才能生效.

Changing the "Encryption Method" setting for a database in the Microsoft Access settings does not automatically re-encrypt the file with the new encryption method. You must un-encrypt and re-encrypt the file for the new encryption method to take effect.

这篇关于更改加密方法后连接到加密的Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！