mdb: Access Microsoft Access .mdb database files
| Recommend this page to a friend! |
 Author |
 |
|
Innovation award Nominee: 3x | |||||||||||||||||||
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.
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 .zip .tar.gz |
> |  Support forum (8) |
> |  Blog |
> |   Latest changes |
|
|||||||||||||||||||||||
| Groups |  User ratings |
Applications |  Files |
| Groups |
 Databases |
Database management, accessing and searching | View top rated classes |
| Files and Folders |
Listing, accessing and manipulating files and folders | View top rated classes |
| Windows |
Use of capabilities specific of the Windows operating systems | View top rated classes |
| Innovation Award |
 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 |
| Ratings | Utility | Consistency | Documentation | Examples | Tests | Videos | Overall | Rank |
|---|---|---|---|---|---|---|---|---|
| All time: | Sufficient (79%) | Good (81%) | Sufficient (75%) | Sufficient (76%) | - | - | Sufficient (63%) | 1031 |
| Month: | Not yet rated by the users | |||||||
| Applications that use this package |
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
| Files |
| File | Role | Description |
|---|---|---|
| class_mdb.php |
Class | The class file |
 example.php |
Example | example |
| issue_date.txt |
Doc. | Known issue with date < 1970 |
 Install with Composer - Download all files: mdb.tar.gz mdb.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
| Files |
| File | Role | Description |
|---|---|---|
| class_mdb.php |
Class | The class file |
| example.php |
Example | example |
| issue_date.txt |
Doc. | Known issue with date < 1970 |
| Install with Composer - 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.
|
