title: Running VBA before any forms open
body: <p>So I have an Access database with a front and a back end.  I will be distributing it to users soon, but I have no control over where exactly they will put the files on their computers.  However, I think I can count on them putting front and back ends in the same folder.</p>
  
  <p>As such, when the front end opens, I want it to check that the linked tables are correctly connected to the back-end database.  I have working code for this; however I don't know where to put it.  When the front end opens, a menu form is automatically opened (configured through the start-up dialogue box).  I have put the code in the <code>OnOpen</code> event, which I thought occurred before any data is loaded, but when I test this out, I get a message telling me that the back-end cannot be found (it's looking in its old location).</p>
  
  <p>Basically, is there an event I can use that runs before any forms have opened?</p>