Access 2K2 to Word 2K2 Mail Merge

[Tom P.]

Hello.

When performing a Mail Merge from Access 2002 to Word
2002 with code from "Microsoft Knowledge Base Article -
209976" every once in awhile a "Data Link Properties"
dialog appears. After clicking OK or Cancel, an error is
generated stating "The database has been placed in a
state by user 'Admin' on machine 'MyMachine' that
prevents it from being opened or locked.", then I am
presented by three or four more boxes of the same message
with "OK/Help" as the option. When finished
clicking "OK", two empty instances of Access are running
in addition to the instance that started the mess (3
altogether). The aggravating part of this is:
1. The problem seems to be intermittent.
2. The same code worked with Access & Word 2000.
3. The only help I've found is "KB Article 295264 - Mail
Merge Wizard Fails with Stored Procedures and Functions"
and states "This article applies only to a Microsoft
Access project (.adp)." and I am using a (.MDB).

Any and all suggestions are greatly appreciated.
Regards,
Tom

 

[Albert D. Kallal]

Try downloading my word merge sample. It will fix all of your problems.

Also, spend some time reading all of the notes on my web site as to HOW I
get a very reliable word merge.

You can fix this working example at:

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

Give the above a try. It will fix your problem.

 

[Tom P.]

Thanks. The code works well and is pretty neat.
I think it will solve my problem.
However, the user will be able to enter carriage
returns. This poses a problem when exported to a text
file. I've tried to replace them with "~~" within the

qu() function

but this causes problems.

Any suggetsions?

 

[Tom P.]

It certainly did!

Thanks for working with me to get my problems corrected.

Thanks Albert.

Reegards,
Tom