PHP Accessing an Access Database

• • Reply

  19 years ago

  by paulfp

  Paul Freeman-Powell

  Liverpool, United Kingdom

  Joined 19 years ago

  I would be very grateful to anyone who could assist me with accessing a Microsoft Access Database (*.mdb) from a PHP in the same way that you do from ASPs.
  

  
  Thanks in advance and God bless you
  

  
  

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  Try using an ODBC connection, set up through Admin Tools \ Data Sources (ODBC). Then you can just use the appropriate PHP odbc commands.
  

  
  (check out http://www.php.net/manual/en/ref.odbc.php)

  Report abuse
• • Reply

  19 years ago

  by gringod

  Gringod

  London, United Kingdom

  Joined 19 years ago

  if you're gonna use odbc, you must remember to set up the database as a system source and not a user source.

  Report abuse