title: Access 2010 - Stop Linked Table Locking Back End DB
body: <p>For simplicity I've created 2 accdb files, 1 called testBE and one called testFE.
  testBE contains one table test. testFE contains one linked table to testBE-test. Both files are on my local hard drive.</p>
  
  <p>How can I prevent the linked table in the front end from completely locking the BE DB? I've gone to options and set 'Default Open Mode' to 'Shared' and 'Default Record Locking' to 'No Locks' but if I open the linked table it creates a .laccdb file for the BE.</p>