We have successfully finished over 520 projects in last 18 years.
ID : 17432965
Greetings,
We are interested to work on this project, please find my comments inline with yours,
1)Microsoft Access VBA Project with MySQL Database Backend
=>OK What version of MS Access you want to use ? Access 2013/2016 ? We can have MySQL as backend, what version of MySQL is it ? We can have MS Access ODBC DSN Less linked tables of MySQL.
2)I already have a PHP web application,..
=>OK, Are you going to have same MySQL for both the PHP and MS Access database ? The performance is little slow for Remote hosted Servers, this just to inform you.
3)The current web application works very well. It is designed for multi-user internet-based access.
=>Ok
4)I need to produce a Microsoft Access VBA project client, that can connect ..
=>Ok, Please confirm that MySQL is on the same server where you are going to run Microsoft Access. In such case you will get a good performance. Even if the MySQL is in Local Area Network(LAN), you can expect good performance. But for hosted internet server it slows down.
5)Later, I will want to merge the new records from the local MySQL ..
=>I am little confused, the local MySQL database, will it be different from the one connected to PHP website ? the data synchronization, I need to review each table for unique fields or we may have to use GUID , because both the databases can have similar new IDs but they would be different data.....I can explain on this through voice