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

  • Thread starter Thread starter Dean
  • Start date Start date
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
 
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
 
Back
Top