Connect Laravel with MS Access as Second database

Asked Jul 24 '16 at 12:53

Active Feb 07 '18 at 07:06

Viewed 2,670 times

4

I have three problems.

Access MS Access with Laravel application.
Connect MS Access as second database with Laravel application, my first database is mysql.
When any new records added in MS Access database, my script copy that records from MS Access to MySql.

asked Jul 24 '16 at 12:53

Waqas Mehmood

199
3
17

Any updates to this? – Lekz Flores May 19 '17 at 03:16
you can connect mysql with odbc connection inside the access and link the table which you want to use – Waqas Mehmood May 19 '17 at 09:13

1 Answers1

1

Create link in MS Access with your MySql database table and now both databases have same data every time.

Procedure for link MySql table in MS Access database. https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html

answered Feb 07 '18 at 07:06

Waqas Mehmood

199
3
17