By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Can I use MySql With Access 2007

P: 10
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.
Feb 16 '08 #1
Share this Question
Share on Google+
8 Replies


ronverdonk
Expert 2.5K+
P: 4,258
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
Feb 16 '08 #2

Scott Price
Expert 100+
P: 1,384
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
Feb 17 '08 #3

mshmyob
Expert 100+
P: 904
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.
Feb 17 '08 #4

P: 10
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).
Feb 18 '08 #5

mshmyob
Expert 100+
P: 904
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).
Attached Files
File Type: zip ODBC setup for MySql and access_v2.zip (306.3 KB, 6956 views)
Feb 18 '08 #6

P: 2
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!
Mar 11 '08 #7

mshmyob
Expert 100+
P: 904
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/de...BCOverview.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/...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!
Mar 11 '08 #8

P: 5
mshmyob it works great
Aug 15 '14 #9

Post your reply

Sign in to post your reply or Sign up for a free account.