Can I use MySql With Access 2007

[Milan Mehta]

I have my application running in Access 2007. Can I use port my database to MySQL and retail Access 2007 as front End ? As this will save lot of my efforts but still get the stability of MySQL.

TIA
Milan.

[ronverdonk]

Point 1: Yes, you can move data from your Access mdb into MyQL using PHP and a db abstraction layer like like ADODB.

On your point 2: I am not so sure that you can, actually I am almost certain you cannot.

So I will copy this thread also to the Access/VBA forum. There are some very skilled experts/members who can help you with the second part.

Ronald