PHP Classes

mdb: Access Microsoft Access .mdb database files

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (8)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 63%Total: 10,010 All time: 137 This week: 114Up
Version License Categories
mdb 1.0.0FreewareDatabases, Files and Folders, Windows


This class is meant to access Microsoft Access .mdb database files by specifying their filenames.

It uses a Windows ADODB COM object to open the .mdb database. From then on you can execute SQL queries and retrieve the result set date like with any SQL based database.

Innovation Award
PHP Programming Innovation award nominee
June 2004
Number 4

Prize: One downloadable copy of PHPEd
Microsoft Access is a popular database manager application for Windows. Despite it is not very suitable for Web database applications that may be updated by many simultaneous users, there is always people willing to use their Microsoft Access database files (.mdb) on the Web.

One of the difficulties of using .mdb files from PHP is that when you use the ODBC API to access the databases, usually you need to setup a Data Source Name (DSN) in the Windows system that works as a server.

This class provides an alternative solution that takes only the path of the .mdb file to access it using Microsoft COM objects.

The class automatically constructs a suitable DSN to instantiate a COM object that can be used to execute and retrieve the result sets of SQL queries that can be run on Microsoft Access databases.

Manuel Lemos
Picture of Peter Klauer
Name: Peter Klauer <contact>
Classes: 18 packages by
Country: Germany Germany
Age: 65
All time rank: 352 in Germany Germany
Week rank: 387 Down15 in Germany Germany Down
Innovation award
Innovation award
Nominee: 3x

  Files folder image Files  
File Role Description
Plain text file class_mdb.php Class The class file
Accessible without login Plain text file example.php Example example
Accessible without login Plain text file issue_date.txt Doc. Known issue with date < 1970

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:137
This week:114Up
User Ratings User Comments (1)
 All time
Perfect!!! I loooove you
15 years ago (ly manh)