Login   Register  
PHP Classes
elePHPant
Icontem

mdb: Access Microsoft Access .mdb database files

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Peter Klauer
Name: Peter Klauer <contact>
Classes: 18 packages by
Country: Germany Germany
Age: 55
All time rank: 302 in Germany Germany
Week rank: 97 Down4 in Germany Germany Down
Innovation award
Innovation award
Nominee: 3x


  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Peter Klauer  >  mdb  >  Download Download .zip .tar.gz  >  Support forum Support forum (8)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: mdb
Base name: mdb
Description: Access Microsoft Access .mdb database files
Version: -
PHP version: -
License: Freeware
All time users: 9350 users
All time rank: 141
Week users: 7 users
Week rank: 219 Down
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes
Group folder image Windows Use of capabilities specific of the Windows operating systems View top rated classes


  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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (78%) Good (80%) Sufficient (72%) Sufficient (75%) - - Sufficient (62%) 718
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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

Download Download all files: mdb.tar.gz mdb.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.