This repository is no longer maintained.

It is recommended to visit the updated repository https://github.com/zoilomora/doctrine-dbal-msaccess that is being maintained and is not limited to the Laravel framework.

Laravel ORM for Microsoft Access DB

This package helps you to manage Microsoft Access DB by ODBC Connection with the integrated Laravel ORM.

Installation

1. Install via composer

composer require zoilomora/laravel-msaccess

2. Add Service Provider to config/app.php in providers section:

\ZoiloMora\AccessServiceProvider::class,

3. Create a DSN with the connection to the database.

4. Add connection to config/database.php in connections section:

'access' => [
    'driver' => 'pdo_access',
    'connection_string' => 'dsn={namedsn}',
    'username' => '',
    'password' => '',
    'table_prefix' => '',
]

5. Replace {namedsn} with the name of DSN.

Connect model with the connection

1. In the model class add the $connection variable like this:

protected $connection = 'access';

License

Licensed under the MIT license

Read LICENSE for more information