title: How to retrieve data for a webpage from an MS Access database with password
body: <p>I have an MS Access database file that I want to copy into a MySQL to serve up on a webpage, the problem is the database is passworded. What I want to do is upload the file to the server then either strip the password or open it using the password so I can then copy it across to MySQL.
  The password is known and cannot be removed at source.
  I would like to do this with PHP if possible.</p>
  
  <p>This is a recurring event, at max twice a day.</p>
  
  <p>Having contacted my hosting the only way to use odbc is to upgrade to dedicated hosting at 10x the price of my current hosting. Looks like this one is a no go unless I can get at the data another way.</p>