title: Control Access from Excel: remote server machine does not exist or is unavailable
body: <p>I'm running a simple script, described below.</p>
  
  <pre><code>Sub New_Liabilities()
  
  MsgBox ("It may take a while for the query to complete; be patient.  Please wait for the 'Done' message to confirm that the task is complete.")
  
      Dim strDatabasePath As String
      Dim PathToDB As String
      Dim accApp As Access.Application
      Set accApp = New Access.Application
  
      PathOfDatabase = ThisWorkbook.Worksheets("Manual_Updates").Range("PathToAccess")
      accApp.OpenCurrentDatabase PathOfDatabase
      accApp.DoCmd.SetWarnings False
      accApp.DoCmd.RunMacro "Macro_Prep_Liabilities"
      accApp.DoCmd.SetWarnings True
      accApp.Quit
      Set accApp = Nothing
  
  ActiveWorkbook.RefreshAll
  
  MsgBox "Done!  All processes complete!!"
  
  End Sub
  </code></pre>
  
  <p>I keep getting an error message that reads: 
  <code>'remote server machine does not exist or is unavailable'</code>.  </p>
  
  <p>The problem occurs on this line:</p>
  
  <pre><code>accApp.DoCmd.RunMacro "Macro_Prep_Liabilities"
  </code></pre>
  
  <p>Access needs to run several update queries and several append queries, and it takes a while for everything to complete.  Sometimes the process crashes after about 10 minutes, sometimes is crashes after about 5 minutes, but sometimes it works fine.</p>
  
  <p>This whole process is running on a UNC network drive.  I think that is contributing to the problem, but still, I believe this should work.  Does anyone have any idea how I can get this straightened out?</p>