PHPackages                             zoilomora/doctrine-dbal-msaccess - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. zoilomora/doctrine-dbal-msaccess

ActiveLibrary[Database & ORM](/categories/database)

zoilomora/doctrine-dbal-msaccess
================================

Doctrine DBAL implementation for Microsoft Access

1.0.4(5y ago)1924610[1 issues](https://github.com/zoilomora/doctrine-dbal-msaccess/issues)MITPHPPHP ^7.4

Since Nov 20Pushed 5y ago2 watchersCompare

[ Source](https://github.com/zoilomora/doctrine-dbal-msaccess)[ Packagist](https://packagist.org/packages/zoilomora/doctrine-dbal-msaccess)[ RSS](/packages/zoilomora-doctrine-dbal-msaccess/feed)WikiDiscussions master Synced today

READMEChangelog (5)Dependencies (4)Versions (7)Used By (0)

Doctrine DBAL for Microsoft Access
==================================

[](#doctrine-dbal-for-microsoft-access)

An implementation of the [doctrine/dbal](https://github.com/doctrine/dbal) library to support **Microsoft Access databases** in **Microsoft OS**.

There are some functionalities that are not supported by Microsoft Access in a PDO-based connection. For these functionalities the implementation uses a direct connection through ODBC.

OS Requirements
---------------

[](#os-requirements)

- Microsoft Access Database Engine Redistributable ([2010](https://www.microsoft.com/download/details.aspx?id=13255) or [2016](https://www.microsoft.com/download/details.aspx?id=54920)).
- Register a **DSN** in **ODBC Data Source Administrator** `odbcad32.exe`.

Installation
------------

[](#installation)

1. Install via [composer](https://getcomposer.org/)

    ```
    composer require zoilomora/doctrine-dbal-msaccess
    ```

### Register a **DSN**

[](#register-a-dsn)

We don't need to reinvent the wheel, on the internet there are hundreds of tutorials on how to set up a DSN for Microsoft Access. I leave you a [video](https://www.youtube.com/watch?v=biSjA8ms_Wk) that I think explains it perfectly.

Once the DSN is configured we will have to configure the connection in the following way:

```
$connection = \Doctrine\DBAL\DriverManager::getConnection(
    [
        'driverClass' => \ZoiloMora\Doctrine\DBAL\Driver\MicrosoftAccess\Driver::class,
        'driverOptions' => [
            'dsn' => 'name of the created dsn',
        ],
    ]
);
```

Discovered problems
-------------------

[](#discovered-problems)

### Character encoding problems

[](#character-encoding-problems)

The default character encoding in Access databases is [Windows-1252](https://en.wikipedia.org/wiki/Windows-1252). If you want to convert the data to UTF-8, a simple solution would be:

```
$field = \mb_convert_encoding($field, 'UTF-8', 'Windows-1252');
```

If you want all the data to be encoded automatically to UTF-8 (with the performance reduction that it may imply) configure the driver as follows:

```
$connection = \Doctrine\DBAL\DriverManager::getConnection(
    [
        'driverClass' => \ZoiloMora\Doctrine\DBAL\Driver\MicrosoftAccess\Driver::class,
        'driverOptions' => [
            'dsn' => 'name of the created dsn',
            'charset' => 'UTF-8',
        ],
    ]
);
```

License
-------

[](#license)

Licensed under the [MIT license](http://opensource.org/licenses/MIT)

Read [LICENSE](LICENSE) for more information

###  Health Score

31

—

LowBetter than 66% of packages

Maintenance19

Infrequent updates — may be unmaintained

Popularity23

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~1 days

Total

5

Last Release

2046d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/8c4eb3322c15a9344e9c086a7de11c3204bf5aab5321b562bf9193f5ee8cd420?d=identicon)[zoilomora](/maintainers/zoilomora)

---

Top Contributors

[![zoilomora](https://avatars.githubusercontent.com/u/4701956?v=4)](https://github.com/zoilomora "zoilomora (14 commits)")

---

Tags

dbaldoctrinemicrosoftmicrosoft-access

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Type Coverage Yes

### Embed Badge

![Health badge](/badges/zoilomora-doctrine-dbal-msaccess/health.svg)

```
[![Health](https://phpackages.com/badges/zoilomora-doctrine-dbal-msaccess/health.svg)](https://phpackages.com/packages/zoilomora-doctrine-dbal-msaccess)
```

###  Alternatives

[martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions.

4585.8M4](/packages/martin-georgiev-postgresql-for-doctrine)[flow-php/doctrine-dbal-bulk

Bulk inserts and updates for Doctrine DBAL

14385.8k4](/packages/flow-php-doctrine-dbal-bulk)[2lenet/crudit-bundle

The easy like Crud'it Bundle.

1616.4k14](/packages/2lenet-crudit-bundle)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)