title: How can I open an Access DB via ADO so that I can write, but others can only read?
body: <p>From the documentation, I would expect adModeShareDenyWrite to be the way, but it's not working right.</p>
  
  <p>I'm using an Access database via ADO.   My connection string says Mode=8, which is adModeShareDenyWrite.   But when I try to delete a row from a table, I get:</p>
  
  <p>Unspecified error, Description:Could not delete from specified tables., Source:Microsoft JET Database Engine</p>
  
  <p>In other words, the setting is preventing ME from updating the database using my OWN connection.</p>
  
  <p>I found a couple other posts on the web reporting the same thing, the adModeShareDenyWrite setting used with Access not working as documented.</p>
  
  <p>I am looking for a solution that doesn't involve an administrator changing permissions.  It needs to be something that my program can control.   </p>
  
  <p>My motivation here is to minimize the chances of database corruption.  One of the causes of mdb file corruption documented by Microsoft is two apps writing to the same db.   So, I want to make sure that only one app can have a write connection to the db.   Others can read, but should fail when they try to write.   Whoever makes a connection first wins.</p>