Good afternoon! I need an orientation / suggestion. It is as follows: we have a clock software where it will record all the markups in a database in MS Access. I need to create a report for each employee in the company intranet, where the same is in PHP and MySQL using Codeigniter framework. I would like to know if the ideal would be to synchronize the MS Access database with MySQL and if this is possible. I need to query the data in MS Access and also record some information in it. I tried to create a new connection inside the codeigniter with Access itself, but I did not succeed. If anyone can guide me please.
Integration into banks
0
asked by anonymous 13.06.2017 / 22:44
1 answer
0
Yes it is possible to integrate Access in PHP through PDO, just the connectionString correct. But you can also use IC. See this answer for a baseline of how to configure the connection within it.
Other threads below may help you too
But if the intranet is in MySQL, I believe it would be more feasible to use it instead of OleDb, and it is much more robust as well. The other option is to also create a job to send to MySQL, but in this case you would need to make the connection open and create another script that would do this.
In any case, both ways are valid, but it would be more advantageous to have everything in a single database.
14.06.2017 / 01:55