title: Disabling security warning on tables imported/linked via VBA
body: <p>How do you stop this window popping up for tables being imported via <code>DoCmd.TransferSpreadsheet</code>?</p>
  
  <p><img src="https://i.stack.imgur.com/R2r30.jpg" alt="Security Warning"></p>
  
  <p>I'm importing quite a few tables, so having to click "open" on this pop-up for each one is annoying.</p>
  
  <p>I've tried <code>DoCmd.SetWarnings False</code> but that doesn't seem to work.</p>
  
  <p>I know that it may also be possible to set the folders that contain the files being imported to trusted locations, but unfortunately I don't have permissions on our network to do that at the moment (I also think that would only affect the settings of my version of Access rather than the Access file I'm creating and distributing).</p>