Automation

[deluxeinformation@gmail.com]

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

[Granny Spitz via AccessMonster.com]

Re: Automation

deluxeinformati on@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.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[deluxeinformation@gmail.com]

Re: Automation

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

[Granny Spitz via AccessMonster.com]

Re: Automation

deluxeinformati on@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.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[deluxeinformation@gmail.com]

Re: Automation


Granny Spitz via AccessMonster.c om wrote:

deluxeinformati on@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.

Just out of curiosity, what is this tool of which you speak?

Bruce

[Granny Spitz via AccessMonster.com]

Re: Automation

deluxeinformati on@gmail.com wrote:

Just out of curiosity, what is this tool of which you speak?

Advertising is prohibited in the newsgroups so I can't give you a link. It's
one of the tools on an Access developer's tool bar I bought from one of the
web sites of people who post in the Access newsgroups. It's not FMS or
Moshannon if that's what you're thinking.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[RoyVidar]

Re: Automation

"Granny Spitz via AccessMonster.c om" <u26473@uwewrot e in message
<69f9eae61feea@ uwe>:

deluxeinformati on@gmail.com wrote:

>Just out of curiosity, what is this tool of which you speak?

>
Advertising is prohibited in the newsgroups so I can't give you a
link. It's one of the tools on an Access developer's tool bar I
bought from one of the web sites of people who post in the Access
newsgroups. It's not FMS or Moshannon if that's what you're
thinking.

I'm perhaps interpreting the charter of this NG differently, but I
thought that "You may answer a question with a link to a commercial
site which pertains to the question." meant that you could do that.

http://www.mvps.org/access/netiquette.htm

--
Roy-Vidar

[Granny Spitz via AccessMonster.com]

Re: Automation

RoyVidar wrote:

I'm perhaps interpreting the charter of this NG differently, but I
thought that "You may answer a question with a link to a commercial
site which pertains to the question." meant that you could do that.

Some people interpret it more loosely and some people interpret it more
strictly. I read the arguments and obscenities in posts in the past from
both sides. I don't want to run afoul of anybody's rules of conduct, so I
try not to post links to commercial sites even if the product is exactly what
I think the poster needs, because I don't want anybody to think I'm their
salesman. There aren't many commercial site links in people's sig lines in
the Access newsgroups, so if you look I'm sure you'll find all the commerical
products in a few minutes, at least I did.

In the spirit of the newsgroups we're offering help, not sales.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200611/1

[RoyVidar]

Re: Automation

"Granny Spitz via AccessMonster.c om" <u26473@uwewrot e in message
<69fa8ea4f5ef8@ uwe>:

RoyVidar wrote:

>I'm perhaps interpreting the charter of this NG differently, but I
>thought that "You may answer a question with a link to a commercial
>site which pertains to the question." meant that you could do that.

>
Some people interpret it more loosely and some people interpret it
more strictly.

Why interpret at all - posting a link to a commercial site which
pertains to the question is explicitly allowed in this NG.

What you do is of course the opposite of what you say - by stating
"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."
you are effectively advertising this product, and doing a darn good job
at it. For a different approach, look at those who follow the charter
and just post a link - here are a couple of samples (watch for
linebreaks in the links)

http://groups.google.com/group/comp.databases.ms-access/msg/c4276896d3bb3c52

http://groups.google.com/group/comp.databases.ms-access/msg/23ef795f6edc4c82

http://groups.google.com/group/comp.databases.ms-access/msg/a5a337a898a52e00

http://groups.google.com/group/comp.databases.ms-access/msg/96ff5b2c1c64fd8b

I read the arguments and obscenities in posts in the
past from both sides.

Would that be after someone has followed the NG charter and posted a
link to a commercial site which pertains to the question?

I don't want to run afoul of anybody's rules
of conduct, so I try not to post links to commercial sites even if
the product is exactly what I think the poster needs, because I don't
want anybody to think I'm their salesman.

When advertising like you do, and then refuse to do the one thing which
is explicitly allowed in this NG (giving the incorrect excuse that
posting links to commercial sites aren't allowed in this NG), what
impression do you think you give?

There aren't many
commercial site links in people's sig lines in the Access newsgroups,
so if you look I'm sure you'll find all the commerical products in a
few minutes, at least I did.

Where does the sigs come into the equotation?

In the spirit of the newsgroups we're offering help, not sales.

Sure, let us all start writing order/invoice systems for small
businesses, video rental systems, small business inventories... from
scratch again, so we can do our utmost to avoid sales and anyone
earning money, eh? Face it, for some challenges posted here,
recommending a commercial solution is a better alternative than
reinventing the wheel... I wouldn't be surprised if that's why the
charter explicitly allows posting links to commercial sites which
pertains to the question.

--
Roy-Vidar

[Lyle Fairfield]

Re: Automation

RoyVidar wrote:

"Granny Spitz via AccessMonster.c om" <u26473@uwewrot e in message

In the spirit of the newsgroups we're offering help, not sales.

>
Sure, let us all start writing order/invoice systems for small
businesses, video rental systems, small business inventories... from
scratch again, so we can do our utmost to avoid sales and anyone
earning money, eh? Face it, for some challenges posted here,
recommending a commercial solution is a better alternative than
reinventing the wheel... I wouldn't be surprised if that's why the
charter explicitly allows posting links to commercial sites which
pertains to the question.

I support Granny's postion on this:

Links and commercial solutions are sterile. Debate, explanation and
hypothesis are the fuel of innovation and of learning.

If someone wants a solution let him/her engage a developer. If someone
wants to learn, let him/her come to CDMA.

[Phil Latio]

Re: Automation

Here, here..... I wholly agree with Lyle's final sentence.

Phil

SNIP

>
Links and commercial solutions are sterile. Debate, explanation and
hypothesis are the fuel of innovation and of learning.
>
If someone wants a solution let him/her engage a developer. If someone
wants to learn, let him/her come to CDMA.

[Granny Spitz via AccessMonster.com]

Re: Automation

RoyVidar wrote:

Why interpret at all - posting a link to a commercial site which
pertains to the question is explicitly allowed in this NG.

Not according to some. Many people hate advertising of any kind. I'd rather
not get in an argument with anybody, including you.

Some people provide links to their web sites in their sig lines. If you're
curious and have time, explore those links. You'll find lots of great tips
and some products that'll save you time and/or money. I know I did. I don't
want to deprive anybody of the adventure of discovery.

Face it, for some challenges posted here,
recommending a commercial solution is a better alternative than
reinventing the wheel.

It won't be me making that recommendation. I think people should learn how
to do it themselves. It's not rocket science but it's a lot of work to learn
how to do it right. And once they learn how, they can apply those skills to
other projects and even teach others. People who answer questions in the
newsgroups are the facilitators for people to build successful database
applications by offering advice and code samples when needed. I don't really
see them as vendors, except for a few whom I'll decline to mention.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200612/1