Microsoft Access or MySQL?

Microsoft Access or MySQL?

Microsoft Access is a popular data management application that allows you to store
information in tables that it manages directly from the local disk. You can also use
Access as a front end, that is, as an interface to information that is located elsewhere
and handled by another storage management system. In this case, Access acts as a
client that connects to a server that provides the data. The MySQL database system is
one such storage manager; if you install the MySQL Connector/ODBC driver
(formerly known as MyODBC), Access can make ODBC connections to MySQL
servers over the network. You can still use the contents of your tables through Access,
but the tables themselves are hosted by the MySQL server.
Access has its strengths, such as an easy to use interface. Access also has its
limitations--it's generally used as a personal or single-user application, typically for
managing limited amounts of data. (Access is not commonly used for databases
hundreds of megabytes in size, for example.) Because of its storage management
limitations, you may be considering how to retain the Access interface but migrate
your information to a storage manager with greater capabilities. Or you may even be
considering a move away from Access entirely. This article outlines some benefits
that you stand to gain by using MySQL to manage your data, and provides some
guidelines to help you migrate locally stored Access tables to MySQL. The final
section of the article lists links to locations where you can find the tools discussed
here.