title: New admin for MS Access, how to modify existing macro
body: <p>I'm a new admin for an MS access database.  I'm very new to MS Access so please forgive me if I ask something that does not make sense here....</p>
  
  <p>The current staff has a small (5MB or so) .mdb file on their desktop.  Clicking that file opens access and lists queries on the left hand side of Access.  I've copied this file to my laptop in an effort to start working/maintaining the databaser.  However clicking any query yields in an error (vice loading/running) that essentially says the network location (file) cannot be found.  </p>
  
  <p>The .mdb file on their desktops includes macros to load the main .mdb file (much bigger at 33MB) via a network share.  Yet when I open this .mdb file from my desktop and view the macros via the macro tab I do not see any macro that tries to load the .mdb file from the network share.  Additionally some of the macros fail.  One in particluar is trying to load the main .mdb file over the network share.  I have the main .mdb file on my desktop and would like to change, amongst other things, that macro to point to the local copy vs. the network copy to which the macro points.  What is the best way to view all macros in an .mdb file of this nature with the intent on modifying them as needed?</p>
  
  <p>EDIT:</p>
  
  <p>I should also mention that I have a new version of Access on my laptop (2010).  Everyone else is using 2003.  Unfortunatley I am unable to install the old version on my laptop due to corporate policy.  As people use the database regulary I ideally need to modify the .mdb file on my laptop which runs 2010...</p>