pedro at plex.nl
pedro at plex.nl
Wed Jan 14 15:08:38 CST 2004
Hello Group, i converted a A97 secured database to A2K. After making the changes in Wrkgadmin.exe and the ODBC Data Sources, i changed the names in the module. After running the mailmerge i get an error: Run-time error '5922' Word was unable to open the data source. The debug selects the .OpenDataSource from the code below. I figure out why this error occurs. TIA Pedro Janssen Sub CreateMergeDoc(UseDDE As Boolean, PrintDoc As Boolean) Dim WordDoc As Word.Document Dim strLetter As String Dim strConnect As String Dim WordApp As Word.Application Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Add With WordDoc.MailMerge If UseDDE Then strConnect = "QUERY Uitvoer" Else strConnect = "DSN=MS Access 2000 " _ & "Database;DBQ=E:\Cytologie\positieven\" _ & "BeveiligdPOSITIEVEN(A2K).mdb;" _ & "FIL=MS Access;" End If .OpenDataSource _ Name:="E:\Cytologie\positieven\BeveiligdPOSITIEVEN(A2K).mdb", _ ReadOnly:=True, LinkToSource:=True, _ Connection:=strConnect, _ SQLStatement:="SELECT * FROM [Uitvoer], [Aanvrager] WHERE Uitvoer.AanvragerID = Aanvrager.AanvragerID AND Uitvoer.ControleID = " & Forms![Brief]![veld] & ";" With Fields ............... End With With WordApp.Selection ............... End With With WordDoc.MailMerge .DataSource.FirstRecord = 1 .Destination = wdSendToNewDocument .Execute If PrintDoc Then .Application.Options.PrintBackground = False .Application.ActiveDocument.PrintOut End If End With WordApp.Visible = True End With End Sub