title: Microsoft 365 Access initial response is slow
body: <p>I'm using Access with vba in excel.
  When accessing a PC (master unit) that has an Access file using the link table from a PC (slave unit) connected via a Windows network, it takes 3 to 7 seconds for the response only for the first time.
  After that, the response is quick, about 0.3 to 0.5 seconds.
  Also, if it takes more than 2 minutes, it will take about 3 or 7 seconds for the first access.
  Does anyone know how to resolve this initial delay?
  I relied on Microsoft's paid support, but it was rejected as out of support.</p>
  <p>I checked the time with the following code.
  (This is Python, but I think the phenomenon is the same in VBA.)</p>
  <pre><code>import pyodbc
  import time
  
  i = 0
  while i&lt;10:
  
  start = time.time()
  order_number = '10007523'
  
  con_str = 'Driver={{Microsoft Access Driver (*.mdb, *.accdb)}};Dbq={0};'.format(r&quot;\\Oshima1\logi\Database_Cancel_Link.accdb&quot;)
  conn = pyodbc.connect(con_str)
  cur = conn.cursor()
  sql = &quot;SELECT * FROM Cancel WHERE order_number='&quot; + order_number + &quot;'&quot;
  cur.execute(sql)
  amount_judge = 'same'
  plus_minus = ''
  for row in cur.fetchall():
      print(row[0])
  
  cur.commit()
  cur.close()
  conn.close()
  
  end = time.time() - start
  print(end)
  
  
  print('----------------')
  #time.sleep(120)
  
  i+=1
  </code></pre>