title: How to read .mdb file in zip folder without unzipping it in MS Access
body: <p>I have a query that would normally look out for and read .mdb files. However lately the .mdb are zipped due to large size. Seeing that adding the zip folder into the path doesn't work. I'm pretty lost. </p>
  
  <p>I've tried adding VBA codes from online forums into the module, but have no idea how they work.</p>
  
  <p>Any help would be greatly appreciated</p>
  
  <p>For reference I'm using MS access 2010.</p>
  
  <p>EDIT: To clarify my question, I currently don't have VBA codes because I have no idea how the previous one works.</p>
  
  <p>My question summed up is basically:</p>
  
  <p>In SQL:
  (BEFORE) <code>Select a,b,c From A,B,C IN "C:\test\test.mdb"</code></p>
  
  <p>(What I want) <code>Select a,b,c From A,B,C IN "C:\test\test.zip\test.mdb"</code></p>
  
  <p>How to read the test.mdb within test.zip without unzipping it?</p>