The RPC Server is Unavailable 
Author Message
 The RPC Server is Unavailable

I've built an Access97 Database application that merges data to Word97
documents. Each record produces a document can be from 1 to 3 pages with
each page resulting from a separate merge of data. I open, print and close
each document. The process is VBA-controlled within Access97. It
successfully runs and is able to print any number of separate documents.
However, if after the first print run has finished, and the user wishes to
print another set of documents, upon printing the first merged document, we
receive a message stating "The RPC Server is Unavailable", and the process
terminates. I have searched this error throughout my literature and have
found no mention of the cause. Here is the core of my merge code: strDocName
= rstStateDocs!AssgnmtDoc1 Set objWord = GetObject(strDocName,
"Word.Document") Set WordApp = objWord.Application WordApp.Visible = True
'Make Word Visible objWord.MailMerge.OpenDataSource _ Name:=strPath ',
Connection:="qry_PrintJob" 'Set the mail merge data source 'Execute the mail
merge objWord.MailMerge.DataSource.FirstRecord = n
objWord.MailMerge.DataSource.LastRecord = n objWord.MailMerge.Destination =
wdSendToNewDocument objWord.MailMerge.Execute PageCount = PageCount + 1
objWord.Application.Options.PrintBackground = False
objWord.Application.ActiveDocument.PrintOut If j <> num Then
Documents(1).Activate Documents(1).Close SaveChanges:=wdDoNotSaveChanges
objWord.Activate objWord.Close SaveChanges:=wdDoNotSaveChanges objWord.Quit
Set objWord = Nothing End if Word stays open during the entire printing
process. I close it after printing the last record. Could you clue me in on
the code I'm missing.

Sun, 07 Dec 2003 06:18:52 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Word Automation RPC Server is unavailable

2. RPC server is unavailable Error

3. Automation Error/The RPC Server is unavailable with Access/Word97

4. RPC Server unavailable...

5. RPC Server is unavailable

6. RPC server unavailable (Office 97)

7. RPC Server is Unavailable

8. Help on "RPC Server unavailable" error

9. The RPC server is unavailable.

10. Error: "The RPC Server is Unavailable"

11. Error: "The RPC Server is Unavailable"

12. RPC server unavailable or not responding


Powered by phpBB® Forum Software