如何从MSACCESS打开MSACCESS时将跳过自动执行宏？ [英] How to skip Autoexec macro when opening MSAccess from MSAccess?

问题描述

所以我有一个MDB MSACCESS需要打开其他MDB的，并运行了一堆code的会比较两个访问MDB的找到code的差别，查询diff文件等。其目标是，以验证任何生产的MDB尚未从原始部署改变。

So I have an MSAccess MDB that needs to open other MDB's and run a bunch of code that will compare two Access MDB's to find code differences,query diffs,etc. The goal being to verify any production MDB has not been altered from the original deployment.

我的问题是，许多这些访问的应用程序有自动执行宏并没有简单的方法来调用.OpenCurrentDatabase而不运行AutoExec宏。

My problem is that many of these Access apps have Autoexec macros and there is no simple way to call .OpenCurrentDatabase without running the autoexec macro.

我如何使用code跳过宏？

How can I just skip the macro using CODE?

我知道我可以按住shift键。我知道我可以把该选项开启和关闭了。

I know I can hold down the shift key. I know I can turn that option on and off too.

推荐答案

code在启动时运行的可能不是一个自动执行宏，它可能是在启动的形式，因此，您不妨考虑一下编程pressing通过API shift键

Code run at start-up may not be in an autoexec macro, it may be in a startup form, therefore, you may wish to consider 'programmatically pressing the shift-key' through APIs:

http://www.mvps.org/access/api/api0068.htm

这篇关于如何从MSACCESS打开MSACCESS时将跳过自动执行宏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！