Home |
Search |
Today's Posts |
#1
|
|||
|
|||
OpenDataSource problem
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 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 |
#2
|
|||
|
|||
I would guess the problem is as follows:
a. you already have the data base open b. the Connection string is the string that you would have used in Word 2000 or earlier to open the database using DDE c. however, the OpenDataSource code you are using will cause Word to try to open the database using OLEDB, not DDE. OLEDB will not recognise this connection string, either. d. OLEDB probably tries to open the database in a sharing mode that is incompatible with the mode it is already open in, and will fail. Possible solutions: e. modify the connection string to specify a mode that will work (not sure this can actually work) f. add the parameter SubType:=wdMergeSubTypeWord2000 to your OpenDataSource call. This shouls make Word open the database using DDE. NB, you probably do not need either of these lines: LinkToSource:=True, _ ReadOnly:=True, _ Peter Jamieson "Phill" wrote in message ... 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 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Problem w/Auto Text and Spell Check and Crashing | Microsoft Word Help | |||
Word 03 Envelope Print Problem | New Users | |||
Problem formatting Wordpad (and often Word) | New Users | |||
Word User Network Problem | Microsoft Word Help | |||
Font Problem in Outlook with Word as E-mail Editor | Microsoft Word Help |