Mailmerge in Word: Suppress opening ACCESS 2000 again

[Guest]

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?

 

[Guest]

Are you running the latest service packs for both products?

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

- Raoul

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

jokobe

 

[Guest]

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