title: MS Access Append Query slow only on Wifi connection
body: <p>I’m using MS Access to insert 100 records into a table on a local SQL server.</p>
  
  <p>When my PC connects via Ethernet to the server, the APPEND query runs in less than a second.</p>
  
  <p>When the same PC connects via WiFi router to this server it takes more than 30 seconds.</p>
  
  <p>Details:</p>
  
  <ol>
  <li><p>PC: Core7 8G RAM running Win10, with all updates installed.</p></li>
  <li><p>MS Access: Ms Access 2003 with all updates installed. I have also tried MS Access 2010.The APPEND query is:</p></li>
  </ol>
  
  <p><code>INSERT INTO dbo_tableA ( A, B, C ) SELECT tableB.X, tableB.Y, tableB.Z FROM tableB;</code></p>
  
  <p>These tables include only 3 indexed integers and a key field. There are no calculated fields and the database was compacted. The same results when using code docmd.runsql. The speed of a SELECT query over the WiFi is fast. </p>
  
  <ol start="3">
  <li><p>Server: Xeon 8G RAM running on Windows Server 2003 with SQL 2005, with all updates installed. No other users connected.</p></li>
  <li><p>Network: The WiFi router includes a multiple ports switch. The Server is connected to this switch directly.</p></li>
  </ol>
  
  <p>No one is currently connected to the Wifi . It’s a 5Ghz 802.11n. 
  The speedtest.xfinity.com results 27Mbps download and 6Mbps upload when running on the Ethernet port and the same results on the WiFi.</p>
  
  <p>Many thanks in advance for any response.</p>