Connecting Tech Pros Worldwide Forums | Help | Site Map

Can I use MySql With Access 2007

Newbie
 
Join Date: Nov 2007
Posts: 10
#1: Feb 16 '08
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's Avatar
Moderator
 
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#2: Feb 16 '08

re: Can I use MySql With Access 2007


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
Reply