title: How do I lock down an Access database on macro-disabled systems?
body: <p>question for you.</p>
  
  <p>So I have this Access 2007 database that I'm trying to lock down so that it can be deployed.  The intent is for multiple users to run the front-end application simultaneously, connecting to the back-end tables over the network.  However, I obviously don't want to give them access to the forms, settings, tables, etc.</p>
  
  <p>I already tried using the <code>ChangeProperty</code> function for</p>
  
  <ul>
  <li>AllowFullMenus</li>
  <li>AllowSpecialKeys</li>
  <li>AllowBypassKey</li>
  <li>AllowShortcutMenus</li>
  <li>AllowBuiltInToolbars</li>
  <li>AllowToolbarChanges</li>
  <li>AllowBreakIntoCode</li>
  </ul>
  
  <p>But whenever anyone without macro's explicitly enabled opens the database, everything opens as if none of these settings are set.  How can I get around this?  I only use like 3 macros in the program, and none of them are related to the opening of the database or locking down the database.</p>
  
  <p>Suggestions?</p>
  
  <p>Thanks.</p>