[AccessD] MySQL Newbie

Arthur Fuller artful at rogers.com
Fri Nov 4 07:45:10 CST 2005


1. You can connect Access to MySQL using ODBC. There is also a connection
from .NET to MySQL.
2. The software itself can be obtained either free or you can purchase it as
part of a support package.
3. There are various management tools available. To my knowledge, none yet
provide a GUI to build sprocs, so you have to write those as text.
4. The standard version uses MySQL ISAM data files, while the Max version
uses the innoDB engine (which provides transactions etc.). In the Max
version you can mix and match both table types.
HTH,
Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: November 3, 2005 12:20 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] MySQL Newbie

Hi All!

I have been keeping an eye on MySQL for sometime now. I have been hesitant
to use it because I have been accustomed to using SQL Server and like using
stored procedures and triggers.
Now that MySQL 5 is out, I very interested in checking it out.

I have some newbie questions.

1) Does Access play nicely with MySQL?

2) Is MySQL really free? Are there fees somewhere for using the software?

3) Does MySQL come with management tools, like Enterprise Manager for SQL
Server?

4) I see there is a Standard version and a MAX version on MySQL.com. What is
the difference?

Thanks!
JR

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list