Access XP/2002 mail merge opens second instance of the database.

D

Dean

I have a mail merge running in Access 97/Word 97 that
works fine. It now has to run in an Office XP environmnet
so I converted the database without issue and attempting
running this mail merge in an XP environment.
Unfortunately, when the runapp application (Word XP), is
invoked, Word XP opens up a second instance of the
database. I can't figure out why that is. In Office 97,
this works cleaninly, it uses state information from the
form/query where it's invoked and uses it. In Office XP,
it doesn't seem to recognize that an instance of the
database is opened and it actually opens a second
instance by invoking it through, not the mapped drive,
but the fully qualified path to the database.
Anyone know why and how to fix?

Thanks
 
A

Albert D. Kallal

Actually, in my experience, usually a97 and word have more trouble with the
"2nd" copying being launched.

Cheryl pointed out a possible fix.

I also have a nice working example..that is "ready" to go....and works in
all versions right up to a2003.

So, it is kind of battle tested..and will work for you.

Give my sample download a try.....there is also instructions on my web site
on how to EASILY use my stuff in your code.

Check out:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Top