解密后，Visual Studio无法识别Access 2007文件 [英] Visual Studio does not recognize Access 2007 file after decrypting

问题描述

我正在使用Visual Studio 2010. 我有一个我试图访问的Microsoft Access 2010（x64）文件。 我构建了数据库，然后进入VS设置并构建了一个连接字符串。

I am using Visual Studio 2010.  I have a Microsoft Access 2010 (x64) file I am trying to access.  I built the DB and then went into VS Settings and built a connection string.

Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C：\Temp \ Database.accdb

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\Database21.accdb

测试连接 - 没问题。 我在Access 2010中使用数据库密码对文件进行了加密（文件 - >加密密码）并添加了" Jet OLEDB ：数据库密码=测试"我的连接
string。

Test connection - No problems.  I encrypted the database with a DB password in Access 2010 (File -> Encrypt With Password) and added "Jet OLEDB:Database Password=test" to my connection string.

测试连接 -  我得到"无法识别的数据库格式"。

Test Connection - I get "Unrecognized database format".

I解密数据库并使用原始连接字符串，我得到"无法识别的数据库格式"。

I decrypt the database and use the original connection string and I get "Unrecognized database format".

我可以在Access 2010中打开文件，但Visual Studio将不再识别它。

I can open the file in Access 2010 just fine, but Visual Studio will no longer recognize it.

我创建了一个新的Access数据库，并从原始数据库中导入了所有对象，VS再次连接就好了。

I created a new Access database and imported all of the objects from the original database and VS connects just fine again.

这是一个错误吗VS&NBSP？; ？访问 我在这里错过了什么吗？ 其他人可以复制这种行为吗？

Is this a bug in VS?  Access?  Am I missing something here?  Can anyone else replicate this behavior?

推荐答案

嗨Justin

Hi Justin

由于Access不属于VSTO技术令人怀疑，你会在这个论坛上获得快速而知识渊博的回应。因此，我将把您的问题转移到Access for Developers论坛，在那里您会找到许多应用专家，他们应该能够帮助您。

As Access is not part of the VSTO technology it's doubtful you'll get a quick and knowledgeable response in this forum. Therefore, I'm going to move your question to the Access for Developers forum, where you'll find numerous application specialists who should be able to help you.

这篇关于解密后，Visual Studio无法识别Access 2007文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！