title: MS Access - "file already in use" error on split database
body: <p>I have a split database in MS Access 2010 on Windows 7.</p>
  
  <p>The back end is on a networked drive in a folder that only some people have write permissions; everyone has read permissions.</p>
  
  <p>Every user has their own copy of the front end stored on their local machine.  </p>
  
  <p>Both BE &amp; FE are set to open as shared, not exclusive, for all users.</p>
  
  <p>If a user with read-only permissions tries to get on while another user with read-only permissions is on, they can get on fine.</p>
  
  <p>If a user with read-only permissions tries to get on while a user with write permissions has it open, they get a message saying " file already in use" and they can't open the database.</p>
  
  <p>If a user with write permissions tries to open the database while a user with read-only permissions has it open, it opens as read-only for this user as well.</p>
  
  <p>Do ALL users of a split database need full access?  I really don't want everyone to be able to make edits.  Anything I can do to get this to work?</p>