title: Access - allow updates of data, but only through forms
body: <p>Is it possible, in Microsoft Access 2007, to allow a user to select and update data only when they are editing via a form?</p>
  
  <p>I have a form which contains a datasheet of a foreign table (which in turn has another subtable). I want the users to only edit their own content via the datasheet in the form.</p>
  
  <p>Running a SQL backend, so stored procedures can be used and they can only execute the ones they have EXECUTE rights to.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>Can the table be hidden in Access and the user unable to show it, unless they are the database owner? Alternatively, how can you have subdatasheets run a stored procedure to update, instead of editing the table directly? I want to keep the ability to 'drill down' into related tables.</p>