blocks|key|2741664|text|好的，过一段时间我有了解决办法。谢谢你给了我正确的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2741665|微软的这篇文章非常有用。|offset|length|2741666|在AutoExec宏中，我有两行：|2741667|第一行：Conditions:+[CurrentProject].[IsTrusted]=False，然后选择要打开的女巫形式，在本例中是“关于安全警告表单的信息”。|style|CODE|2741668|第二行：Conditions:+[CurrentProject].[IsTrusted]=True，现在打开“开始菜单表单”|2741669|仅此而已！|2741670|entityMap|0|LINK|mutability|MUTABLE|url|http://support.microsoft.com/kb/931407^0|0|3|4|0|0|0|4|1A|0|4|19|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|F|3|G|5|6|7|12|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@$D|14|E|15|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|16|8|@$D|17|E|18|J|K]]|9|@]|A|$]]|$1|N|3|O|5|6|7|19|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W]]]]

Ok, after a while I have the solution. Thanks for the answers who led me the right way.

<a href="http://support.microsoft.com/kb/931407" rel="noreferrer">This article</a> from Microsoft is very helpful.

In the AutoExec-macro, I have two lines:

Line one: <code>Conditions: [CurrentProject].[IsTrusted]=False</code> and then I choose witch Form I want to open and in this case it is the "info about security warning form"

Line two: <code>Conditions: [CurrentProject].[IsTrusted]=True</code> and now open the "start menu form"

And that's all!

blocks|key|1139365|text|如果该内容被禁用，则无法检查，因为您的代码无法运行.|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1139366|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If the content is disabled, then you cannot check, since your code cannot run....

blocks|key|2741610|text|您可能希望考虑一个启动表单(“信息”)。这将显示没有宏。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2741611|此外，您还可以运行一些启动代码或宏来关闭信息表单并打开主窗体(“开始菜单”)，如果不允许宏，这将不会运行。不过，我想你可能会收到一个难看的警告。|2741612|编辑|2741613|将计时器间隔设置为100，并向Information添加一些代码：|2741614|Private+Sub+Form_Timer()
+++DoCmd.Close+acForm,+"Information"
+++DoCmd.OpenForm+"start+menu"++++
End+Sub|code-block|syntax|javascript|2741615|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You might like to consider a start-up form ("information"). This will show without macros.

In addition, you can run some start-up code or a macro that closes the information form and opens the main form ("start menu"), if macros are disallowed, this will not run. However, I think you may get an unsightly warning.

EDIT

Set the timer interval to say, 100 and add a little code to Information form:

<pre><code>Private Sub Form_Timer()
 DoCmd.Close acForm, "Information"
 DoCmd.OpenForm "start menu" 
End Sub
</code></pre>

blocks|key|1139415|text|只是想补充一下我的解决方案--我只是在处理这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1139416|默认情况下，在数据库选项中，是否将其设置为打开此“未启用”窗体上的表单"notEnabled“，拥有一些文本、图片或让用户知道他/她需要‘启用内容’的内容。|1139417|在此表单的on事件中，只需放置一些VBA来打开您希望用户显示的实际表单，并关闭"notEnabled“表单。|1139418|这样，如果用户打开数据库而不使其可信，启用内容，他们就会被困在告诉他们如何做的表单上。一旦被信任，表单的on事件将触发并将用户重定向到您想要的任何表单，并启用内容。|1139419|如果用户打开数据库并已经信任该文件，则不会看到表单告诉他们要使其可信。|1139420|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Just to add my solution -- I was just dealing with this issue.

By default, in database options have it set to open with form "notEnabled"
On this "not enabled" form, have some text, pictures, or what have you that lets the user know that he/she needs to 'enable content'.

In the on load event for this form, just put some VBA to open the actual form you want the user to be presented and close the "notEnabled" form. 

This way, if the user opens the database without making it trusted, enabling content, they are stuck on the form that tells them how to do that. As SOON as it's trusted, the on-load event of the form will fire and redirect the user to whichever form you want, with content enabled.

If the user opens the database and already has trusted the file, they don't see the form telling them to make it trusted.

blocks|key|1139395|text|您可以通过在您的IsTrusted宏中将AutoExec标志设置为TRUE来避免这种情况。请参阅将现有访问应用程序转换为Access+2007+--搜索IsTrusted，让您了解如何处理它的解释的核心。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1139396|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/bb203849.aspx^0|1C|N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can avoid this by setting the IsTrusted flag to TRUE in your AutoExec macro. See <a href="http://msdn.microsoft.com/en-us/library/bb203849.aspx" rel="nofollow noreferrer">Transitioning Your Existing Access Applications to Access 2007</a> -- search for IsTrusted to get you to the heart of the explanation of how to handle it.

blocks|key|2741744|text|我不知道为什么人们给出的建议还没有经过测试。我的解决方案很简单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2741745|If:+CurrentProject.IsTrusted=False+RunMenuCommand:+CloseDatabase|2741746|否则|2741747|If:+CurrentProject.IsTrusted=True+RunCode：(首先运行您想要的代码或宏)|2741748|如果出现安全警告，这基本上关闭了数据库。如果不是的话，它就会开得很好。管理员的用户将需要降低任何想要访问数据库的人在计算机上的宏安全级别。与其他宏不同的是，这个宏实际上会运行，因为它符合Access的要求。|2741749|不客气！|2741750|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

I don't know why people give suggestions that have not been tested yet. My solution is simple:

If: [CurrentProject].[IsTrusted]=False
RunMenuCommand: CloseDatabase

Else

If: [CurrentProject].[IsTrusted]=True
RunCode: (you run the code or macro you wanted to in the first place here)

This basically closes the database if the security warnings are coming on. If they are not, it opens just fine. The user that is the admin will need to decrease the macro security levels on the computer of whoever wants to access the database. This macro unlike others will actually run because it agrees with what Access wants.

You're Welcome!

When a user start an Access 2007 database that have macros and vba, a security warning is shown. I want the user to deal with this warning, so if the the content is't enabled, the user should not be able to use the database.

Now I use a macro named <code>AutoExec</code> (opens a form that works like a menu), and that macro is run before the user deal with the security warning. But I want to check if the content is enabled and if not I will show a form that inform the user that they should enable the content.

So what I'm actually asking for is how do I do this:

<ol>
<li>If vba and macros is not enabled -> show form "information"</li>
<li>If vba and macros is enabled -> show form "start menu"</li>
</ol>

How to force user to deal with the Security Warning when starting Access 2007?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当用户启动具有宏和vba的Access 2007数据库时，将显示一个安全警告。我希望用户处理这个警告，所以如果没有启用内容，用户就不能使用数据库。现在我使用一个名为AutoExec的宏(打开一个像菜单一样工作的表单)，该宏在用户处理安全警告之前运行。但是我想检查是否启用了内容，如果没有，我将显示一个表单，通知用户他们应该启用内容。所以我要问的是我该怎么做如果vba和宏未启用，则 ->显示表单“信息

问如何在启动Access 2007时强制用户处理安全警告？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在启动Access 2007时强制用户处理安全警告？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在启动Access 2007时强制用户处理安全警告？
EN