Moving MS Access queries to MySQL Database
My current MS Access app uses ODBC to connect to a MySQL database, but all the queries are in Access.
I'm trying to improve performance in certain areas of the application, and its occurred to me that moving some queries to the database side might accomplish that.
I have some general questions about going down that path:
1. Access has that very handy graphical interface for generating SQL syntax, can I simply copy and paste the sql syntax into mysql? (I currently use Navicat to manage the MySQL database)
2. Is there anyway to pass the filtering parameters to the sql query in MySQL from MS Access?
3. Do I then simply link my Access app to the query in MySQL and use it in MS Access as I would any other linked datasource?
Thanks,
David
I'm trying to improve performance in certain areas of the application, and its occurred to me that moving some queries to the database side might accomplish that.
I have some general questions about going down that path:
1. Access has that very handy graphical interface for generating SQL syntax, can I simply copy and paste the sql syntax into mysql? (I currently use Navicat to manage the MySQL database)
2. Is there anyway to pass the filtering parameters to the sql query in MySQL from MS Access?
3. Do I then simply link my Access app to the query in MySQL and use it in MS Access as I would any other linked datasource?
Thanks,
David
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Haven't used mySQL myself, but one of the old stand by's was:
http://www.amazon.com/SQL-Access-Susan-Sales-Harkins/dp/1893115305
However at this point it's a bit outdated and I'm not sure how much it actually gets into mySQL. I though Martin had written a specific book for Access to mySQL, but I can't seem to find it (I'll check with him).
Learn Dev Now has a nice lib of developer training videos, although I'd have to check what they have on mySQL.
Jim.
http://www.amazon.com/SQL-Access-Susan-Sales-Harkins/dp/1893115305
However at this point it's a bit outdated and I'm not sure how much it actually gets into mySQL. I though Martin had written a specific book for Access to mySQL, but I can't seem to find it (I'll check with him).
Learn Dev Now has a nice lib of developer training videos, although I'd have to check what they have on mySQL.
Jim.
This might get you started:
http://artfulsoftware.com/mysqlbook/sampler/mysqled1.pdf
and I believe it's the one I was thinking of (had the wrong author in mind).
Thought either Martin or Aurther had written a specific Access to mySQL book though...
Jim.
http://artfulsoftware.com/mysqlbook/sampler/mysqled1.pdf
and I believe it's the one I was thinking of (had the wrong author in mind).
Thought either Martin or Aurther had written a specific Access to mySQL book though...
Jim.
BTW, don't be afraid to check out Arther's site in general:
http://artfulsoftware.com/index.php
I'll check with him too if there wasn't an Access specific book he wrote.
Jim.
http://artfulsoftware.com/index.php
I'll check with him too if there wasn't an Access specific book he wrote.
Jim.
ASKER
Perfect. Just what i was looking for. Thanks!
I checked with Martin and Arthur; no Access to mySQL specific book. The two links above is what each has done.
The one I was apparently thinking of is the book from Martin.
Jim.
The one I was apparently thinking of is the book from Martin.
Jim.
ASKER
Thanks. Tell Arthur I just bought his ebook and am still eargerly waiting for delivery. :-)
ASKER
I can't decide if it would be a good thing if someday all this technology stuff was standardized, or not. It sure is a pain in the #$&$^ when it isn't.
The price of innovation at the cost of a lot a rework. hmmm. :-)
Do you know of any good reference material/links to learn the MySQL query syntax? I see Oracle offers some online self stufy courses for MySQL in the $1,500 range.. Yeah, right.