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

[Scott Price]

I was waiting for some of the more skilled experts to answer this one, but I see no one has gotten to it yet!

Actually I'm pretty sure that Access 2007 can do the same as all other versions of Access, which is separate the front-end (forms, queries, reports) from the back-end (tables/data). The front-end can link to just about any back-end, including MySQL (as long as it has ODBC support).

With that said, I'm NOT an expert in doing the linking between these two, so if you need more help, I can solicit more expert advice from others.

Regards,
Scott

[mshmyob]

yes you can use Access 2007 as the front end and MySql as a backend. If you need help to do it I can post instructions.

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.

[Milan Mehta]

I will be highly obliged to get instructions on using Aceess 2007 as front end and MySQL as back-end. At present I have my data in MDB format and front-end in Accdb (Access 2007).

[mshmyob]

Here is the detailed instructions with screen shots to setup connecting Access 2007 to MySQL backend. In Word format.

I will be highly obliged to get instructions on using Aceess 2007 as front end and MySQL as back-end. At present I have my data in MDB format and front-end in Accdb (Access 2007).

[fjohnson]

This is exactly what I also was looking for. My question is how will performance be? Will it be slow since I would have to use ODBC drivers?
Thanks!

[mshmyob]

The performance is very good. Performance issues are mostly based on your table designs, programming techniques, hardware, and overall network traffic to name a few.

A lot of ODBC issues have been over come but you can check around for tweaks.

Some links are

http://support.microsoft.com/kb/128808

http://www.granite.ab.ca/access/performancefaq.htm

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_MicrosoftOfficeDeveloperForumMicrosoftAccessODBCOverview.asp

MySQL site has some stuff also but not related to performance and tweaking but still interesting.

http://dev.mysql.com/doc/refman/5.0/en/myodbc-connector.html

cheers,

This is exactly what I also was looking for. My question is how will performance be? Will it be slow since I would have to use ODBC drivers?
Thanks!

[chasstuart]

mshmyob it works great