title: Trying to write to one table with multiple forms in Access
body: <p>After searching around the forums I can find multiple issues with having several tables and one form, however I have the inverse problem.  I have four separate forms that are all linked to the same table.  No two forms edit the same variable on the table.  </p>
  
  <p>If people open up a single form, save it, close it, then move on to the next form the database works as intended.  However, some people open up all the forms and forget to save/close the one beforehand.  At this point, Access refuses to save the file stating that 'Another user has this file open' since the table is open in another form, even though no variable should overwrite each other.</p>
  
  <p>Is there any workaround for this?  I'd just like to have people be able to save their entered data from several forms to the same table.  There will be no point in time that two people would access this table simultaneously, I just want to make sure we can save the data if someone opens multiple forms at once.</p>