MailMerge problem

[Phill]

I have and Access 2003 (saved as Access 2000 format) database using Word 2003
to do a simple mail merge. I get a message that says it couldn't open the
document. When I try to manually do the merge, and test the connection, I
get a message saying "test connection failed because of an error in
initializing provider. The database has been placed in a state by user
'Admin' ...that prevents it from being opened." When I close my database and
test the connection it works. I've tried this several times with the same
results. Any ideas? Thanks. Phill

 

[Phill]

Here is my code.

Set WordDoc = GetObject(strFinalDoc, "Word.Document")
WordDoc.Application.Visible = True

WordDoc.MailMerge.OpenDataSource _
Name:=CurrentDb.Name, _
LinkToSource:=True, _
ReadOnly:=True, _
Connection:="TABLE tempMailMerge", _
SQLStatement:="SELECT * FROM tempMailMerge"

WordDoc.MailMerge.Execute

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UGhpbGw=?=,

I have and Access 2003 (saved as Access 2000 format) database using Word 2003
to do a simple mail merge. I get a message that says it couldn't open the
document. When I try to manually do the merge, and test the connection, I
get a message saying "test connection failed because of an error in
initializing provider. The database has been placed in a state by user
'Admin' ...that prevents it from being opened." When I close my database and
test the connection it works. I've tried this several times with the same
results.

If any changes are made to "code" portions of the database, or if you have query
open in Design View, the OLE DB provider can't make a connection. Have you tried
testing this in the same state as you expect the user to work with it?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail