title: MS ACCESS Lock a table during update, blocking
body: <p>How can I lock a table preventing other users querying it while I update its contents?</p>
  
  <p>Currently my data is updated by wiping the table and re-populating it (i know, its not the best way to update data, but the source data has no unique key to do a record by record update and this is the only way). There exists the unlikely, but possible scenario where a user my access the table in the middle of the update and catch it while it is empty thus returning bad info.</p>
  
  <p>Is there at the SQL (or code) level a way to create a blocking statement that will wait for a DB update to complete prior to querying?</p>