title: Network file path not opening in VBA/MSAccess
body: <p>I'm using VBA in MS Access, and one of the subs takes a file path in a network, checks if the file exists or not, and write the result of a query on it.
  The problem is that when I try to run the code, it gives me error 52 (Bad file name or number). But if I open the network path in windows explorer first, for example, after that the error doesn't happen anymore. Any ideas on what the problem might be?</p>
  
  <p>Here is some of the code I'm running:</p>
  
  <pre><code>fpath = "\\networkpath\file.txt"
  DeleteFile fpath
  
  Sub DeleteFile(ByVal FileToDelete As String)
      FileExists(FileToDelete) Then
          SetAttr FileToDelete, vbNormal
          FileToDelete
      End If
  End Sub
  
  Function FileExists(ByVal FileToTest As String) As Boolean
      FileExists = (Dir(FileToTest) &lt;&gt; "") 'this is where the error happens
  End Function
  </code></pre>