I am developing the backend for a ASP web site. The content of the database will be managed (and entered using Access). The plan is to use Microsoft SQL Server to develop the database and create a Microsoft Access Project, .adp (not an Access database .mdb) to connect to the database. However the problem is that some of the tables of the database will be replicated in another database for a PHP web site, most likely using mySQL. Can tables from a MSSQL database be replicated in mySQL? A solution would be to only use mySQL, can it be used with a MS Access Project?
Using mySQL with a MS Access Project
- Thread starter admin
- Start date