[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error - The remote server machine does not exist or is unavailable

Posted on 2006-11-16
2
Medium Priority
?
465 Views
Last Modified: 2012-06-27
Hello - I'm getting this error message in a mail merge I'm doing from Access. It seems to be a common problem; 1st time through, it works fine, then blows up the 2nd time.

I've followed the advice I've found about declaring specific object variables for the Word app & doc, and then closing and setting them to Nothing at the end of the routine, but I'm still getting the error.

This started happening when I added a routine to loop through ActiveDocument.Tables (to set the font, size and column widths). It blows on the 2nd time through on the line:
     For Each tbl in ActiveDocument.Tables

Is there another object variable for the mail merge result that has to be set to empty?

Any help much appreciated

Thanks

Mark
0
Comment
Question by:mlagrange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
Deb8stud earned 2000 total points
ID: 17961366
Try decompiling your database.  It sounds like you may have so many variables that are active but out of scope that your database is freaking out.  
http://www.granite.ab.ca/access/decompile.htm
0
 

Author Comment

by:mlagrange
ID: 17984184
Thanks - that could explain a lot of things I'm seeing
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question