自动化 [英] Automation
问题描述
你好，
我的机器上安装了两个版本的Access，XP和2003.我想要自动创建一个版本的过程ADE分发给运行混合使用XP和2003的最终用户
。我做了我所有的开发工作。* b $ b在2003年工作但是使用XP创建了最终的ADE。我想在2003年创建一个
小应用程序，打开第二个应用程序（通过自动化在XP中的ADP）
并设置各种选项，然后创建一个ADE 。如果我在Access 2003中启动一个
应用程序，这个应用程序是否可以使用自动化在Access XP中启动第二个应用程序？如果是这样，我是如何指定使用XP打开第二个应用程序的？
？任何
帮助升值。谢谢。
布鲁斯
de *************** @ gmail.com 写道：
< blockquote class =post_quotes>
如果我在Access 2003中启动一个
应用程序，这个应用程序是否可以在Access XP中启动另一个应用程序
使用自动化？
除非你有一个工具在其他版本的Access中创建ADE，否则你将会遇到一些困难。我不确定市场上是否有任何东西。
我买了一个从Access 2003创建Access 2000 MDE的工具，但它只有
创建了MDE ，而不是ADE，也不适用于Access 2002.
如果您的计算机设置为Access 2002默认并使用较晚的
绑定，则可能会这样做，但你必须获得
第二个Access窗口的句柄。那是困难的部分。有一个技巧，因为
当你使用Windows
API时，只返回Access的第一个实例，我忘了这个诀窍是什么。
您可以尝试通过弹出并向Access 2002提供完整路径
来自动执行任务，以打开目标数据库并执行运行的宏
代码你已经放在目标数据库中的一个模块中，
编译模块，然后创建一个ADE文件，然后从
ADE文件。
-
通过AccessMonster.com发布消息
http：//www.accessmonster.com/Uwe/For ... ccess / 200611/1
谢谢。我认为最棘手的部分就是让A2003启动A2002的自动化实例。我可以使用shell但我真的需要
自动化才能完成我必须做的所有初步工作
（比如设置各种选项，检查参考，更改版本<在创建ADE之前，我需要使用
数字等。如果我不能得到A2003
自动化A2002那么我可能会完全按照我需要的那样完成
A2002这不是一个大问题。再次感谢您的回复！
布鲁斯
de *************** @ gmail.com 写道：
我可以使用shell但我真的需要
自动化才能完成我必须做的所有初步工作
（如设置在创建ADE之前，各种选项，检查参考，更改版本
数字等。
其中一些可以从Access 2003应用程序自动执行，但有些东西需要检查需要特定版本的引用（Microsoft Access
10.0对象库，而不是11.0）需要在转换为ADE之前在Access 2002中完成，因此从Access 2002自动化更有意义。很高兴
我有一个工具在我从Access 2003创建一个
Access 2000 MDE之前为我处理这些东西，所以我不必担心其中任何一个。
-
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200611/1
Hello,
I have two versions of Access installed on my machine, XP and 2003. I
am trying to automate the process of creating an ADE for distribution
to end users running a mix of XP and 2003. I do all my development
work in 2003 but create final ADE''s using XP. I''d like to create a
small app in 2003 that opens a second app (an ADP in XP via automation)
and sets various options and then creates an ADE. If I start an
application in Access 2003, is it possible for this application to
start a second application in Access XP using automation? If so, how
do I specify that the second application is to be opened using XP? Any
help appreciated. Thanks.
Bruce
de***************@gmail.com wrote:If I start an
application in Access 2003, is it possible for this application to
start a second application in Access XP using automation?Unless you have a tool that creates ADEs in other versions of Access, you''re
going to have some difficulties. I''m not sure there''re any on the market yet.
I bought a tool that creates Access 2000 MDEs from Access 2003, but it only
creates MDEs, not ADEs, and not for Access 2002 either.
If you have your computer set up with Access 2002 as the default and use late
binding, you can probably do this, but you have to get the handle of the
second Access window. That''s the hard part. There''s a trick to it because
only the first instance of Access will be returned when you use the Windows
APIs, and I''ve forgotten what that trick is.
You could try to automate the task by shelling out and giving the full path
to Access 2002 to open your target database and execute a macro that runs
code you''ve already placed in one of the modules in the target database that
compiles the modules, then creates an ADE file, then deletes the macro from
the ADE file.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1
Thanks. I think the trickiest part is simply getting A2003 to start an
automated instance of A2002. I could use shell but I really need
automation to be able to do all the preliminary stuff I have to do
(like setting various options, checking references, changing version
numbers, etc.) before I create the ADE. If I can''t get A2003 to
automate A2002 then I''ll probably just do what I need to entirely in
A2002 which is not a huge problem. Thanks again for the response!
Bruce
de***************@gmail.com wrote:I could use shell but I really need
automation to be able to do all the preliminary stuff I have to do
(like setting various options, checking references, changing version
numbers, etc.) before I create the ADE.Some of that you can automate from an Access 2003 application, but things
like checking references which require a specific version (Microsoft Access
10.0 Object Library, not 11.0) needs to be done in Access 2002 before
conversion to an ADE, so automating from Access 2002 makes more sense. Glad
I have a tool that takes care of that stuff for me before it creates an
Access 2000 MDE from Access 2003, so I don''t have to worry about any of that.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1
这篇关于自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
