数据库具有密码时从Access导出到Excel [英] Exporting from Access to Excel when the database has a password

问题描述

我在应用程序中编写了一个小型导出程序，以便用户可以将有关供应商的信息导出到Excel电子表格中.我下面有一些几乎可以正常工作的代码.

I've written a small export program in my application so that the user can export information about suppliers into an Excel spreadsheet. I've got some almost fully working code, below. 

我唯一遇到的困难是，当它打开Excel文档时，它还在下面显示一个对话框，并且在按启用"后要求用户输入数据库密码-用户不知道该密码. ，所以我需要一种防止这种情况的方法 从发生.

The only thing I am having difficulty with is that when it opens the Excel document, it displays a dialog, also below, and after pressing 'Enable' asks the user to input the database password - Which the user won't know, so I need a way of preventing this from happening.

为什么出现此对话框?然后我该如何解决输入密码的问题呢?

Why does this dialog appear? And how can I can get around entering the password afterwards?

我的代码；

推荐答案

大卫，您好，

感谢您在MSDN论坛中发帖.

Thank you for posting in MSDN Forum.

>>为什么会出现此对话框?然后我该如何解决输入密码的问题?

根据您的描述，建议您在信任中心的外部内容"部分中启用数据连接或工作簿链接的自动更新，请按照以下步骤操作:

Based on your description, I suggest you could enable the automatic update for data connections or workbook links in the External Content section of the Trust Center, please follow these steps:

1.单击Microsoft Office按钮，然后单击Excel 选项.

1. Click the Microsoft Office Button, and then click Excel Options.

2.点击信任中心.

3.点击信任中心设置.

4.点击外部内容.

5.单击以选择以下选项，以适合您的情况:

5. Click to select the following options, as appropriate for your situation:

• 提示用户有关数据连接
• 提示用户自动更新工作簿链接.

6.点击确定.

有关更多信息，您可以参考: https://computersolution.wikispaces.com/Microsoft+Office+has+identified+a+potential+security+concern

For more information you could refer that: https://computersolution.wikispaces.com/Microsoft+Office+has+identified+a+potential+security+concern

希望这将帮助您解决问题.

Hope it will be help you to solve your issue.

最好的问候，

Neda Zhang

Neda Zhang

这篇关于数据库具有密码时从Access导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！