title: Using Excel To Read From Access Without MS Access Installed On Computer
body: <p>I have written code that joins two table in access, using criteria supplied from drop down lists in Excel and then returns the data to a specific location on the spreadsheet (titles already on the sheet). </p>
  
  <p>This works fine on my box and others with MS Access on the machine, but the purpose of writing this was to give people (associates) that don't have MS Access on their machines (which is most of them) to be able to do simple queries to the database. </p>
  
  <p>When we try to run this on a machine without MS Access, we are getting the error message </p>
  
  <blockquote>
    <p>"Compile Error: Can't find project or library." </p>
  </blockquote>
  
  <p>Since this works fine on any machine so far that has Access, but not the others I am wondering if this is not possible without the actual Access software. Any help or insight would be appreciated.</p>