G+_Matthew Reardon Posted January 19, 2015 Share Posted January 19, 2015 If I want serve up data from an Access database using php, what is my best bet? Should I convert Access database to mySQL? Seems like I can connect Access database using php. Not sure what the best way to approach this. Link to comment Share on other sites More sharing options...
G+_Jeff Brand Posted January 19, 2015 Share Posted January 19, 2015 Wow. Last time I tried to do that, Access support was in alpha. +1 for migration to MySQL. There are subtle differences between SQL on either engine and it's definitely possible either way. It depends on where you see yourself developing in the long-term. Also, here's a cool feature: If you want to maintain compatibility with an Access database, the MySQL ODBC connector for Windows will connect to a remote data source but still allow you to use Access UI (forms, reports, etc.) Again, more quirks to learn there but I've done it and it works well enough. Link to comment Share on other sites More sharing options...
Recommended Posts