Mailmerge in Word: Suppress opening ACCESS 2000 again

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jokobe - 14 Mar 2005 15:17 GMT

I'm starting a mailmerge from ACC2000 like this:
Set wordObj = CreateObject("word.application")
wordObj.Visible = True
wordObj.Documents.Open case_file
wordObj.Documents(case_file).Activate

In case_file the file name is stored. Every time the
file is opened, WORD opens a second instance of the database.
Is there a way to suppress this?

Reply to this Message

JaRa - 14 Mar 2005 16:33 GMT

Are you running the latest service packs for both products?

Are you referencing (mailmerge) the/a database in the word document?

- Raoul

> I'm starting a mailmerge from ACC2000 like this:
> Set wordObj = CreateObject("word.application")
[quoted text clipped - 5 lines]
> file is opened, WORD opens a second instance of the database.
> Is there a way to suppress this?

Reply to this Message

jokobe - 14 Mar 2005 16:49 GMT

Hi Raoul,

thanks for your answer.
- all available updates are installed.
- I'm referencing the query in the word doc.

The reference is needed because the user is working with
the single document before, and then should be able to
start the mailmerge from ACC.

Why is it, that ACC has to be opened again- even if one
instance is running?

> Are you running the latest service packs for both products?
>
[quoted text clipped - 11 lines]
> > file is opened, WORD opens a second instance of the database.
> > Is there a way to suppress this?

Reply to this Message

JaRa - 14 Mar 2005 17:43 GMT

I think it's word which is starting a new access application since the query
which is in the word document so to me it's a bit a world up side down.
Word cannot detect (read use) the access application which you opened already.

Is your data split from you application, so do you use linktables?

- Raoul

> Hi Raoul,
>
[quoted text clipped - 24 lines]
> > > file is opened, WORD opens a second instance of the database.
> > > Is there a way to suppress this?

Reply to this Message

jokobe - 15 Mar 2005 12:07 GMT

The database is split and I'm starting word from the frontend, within the
word document a query from the frontend is used.

jokobe

> I think it's word which is starting a new access application since the query
> which is in the word document so to me it's a bit a world up side down.
[quoted text clipped - 32 lines]
> > > > file is opened, WORD opens a second instance of the database.
> > > > Is there a way to suppress this?

Reply to this Message

JaRa - 15 Mar 2005 13:45 GMT

then I would suggest to transfer the query to the backend and use the backend
in word.
This query you can transfer easily by using VBA before you start the word app.

- Raoul

> The database is split and I'm starting word from the frontend, within the
> word document a query from the frontend is used.
[quoted text clipped - 37 lines]
> > > > > file is opened, WORD opens a second instance of the database.
> > > > > Is there a way to suppress this?

Reply to this Message