Home arrow MySQL arrow Page 6 - MySQL and ODBC

Conclusion - MySQL

Learn it from start to finish.Installing MyODBC, creating a new data source through the ODBC Data Source Administrator, linking a MySQL database into a new MS Access database, and finally updating the MySQL database through an MS Access GUI.

TABLE OF CONTENTS:
  1. MySQL and ODBC
  2. The Sample Project
  3. The MS Access GUI
  4. Importing and Linking the Data Source
  5. Updating The Database
  6. Conclusion
By: W.J. Gilmore
Rating: starstarstarstarstar / 51
February 12, 2001

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
This tutorial was intended to instruct the reader on how a MySQL database can be easily connected to MS Access using the MyODBC drivers. A number of topics were covered, including:
  • How to install the MyODBC drivers
  • Creating a new ODBC Data Source through the ODBC DSA.
  • Linking the ODBC Data Source to an MS Access database
  • Updating the MySQL database through an MS Access GUI

  • Hopefully, the information provided has introduced you to a whole new methodology for providing your clients with an easy solution for maintaining MySQL data. If you create any particularly interesting applications using the information found in this tutorial, I would love to hear about it!

     
     
    >>> More MySQL Articles          >>> More By W.J. Gilmore
     

    blog comments powered by Disqus
       

    MYSQL ARTICLES

    - Xeround Releases Free Version of MySQL Cloud...
    - Oracle Announces New MySQL Specialization
    - Constant Contact Chooses SkySQL for MySQL Su...
    - Revoke Statement in MySQL
    - The Grant Statement in MySQL
    - SuccessBricks Announces ClearDB Availability...
    - Building a PHP ORM: Deploying a Blog
    - TROSYS Launches Free MySQL Manager and Admin...
    - Building an ORM in PHP: Domain Modeling
    - Building an ORM in PHP
    - MySQL Leads Open Source Market, Gets Cluster...
    - Oracle Announces Milestone Release for MySQL
    - How to Stop SQL Injection Attacks
    - New Defragmentation Solution for SQL Server
    - Comparison of MyISAM and InnoDB MySQL Databa...


    © 2003-2012 by Developer Shed. All rights reserved. DS Cluster 9 - Follow our Sitemap

    Dev Shed Tutorial Topics: