Home arrow MySQL arrow Page 3 - MySQL and ODBC

The MS Access GUI - 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.

  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


Synchronizing the MySQL database to an Access GUI may seem like a rather difficult feat; On the contrary, however, it is actually a fairly simple procedure, carried out in just a few steps. The first steps is simply to fire up MS Access. Upon doing so, the user will be greeted with a screen very similar to the one shown in Figure 1-3.

Figure 1-3: Initial MS Access Window

Choose the radio button at the top of the window, labeled Blank Access Database, and press OK. A new window will appear, prompting for a location in which to save the new database. Name the new database widgets.mdb, and navigate to the location in where the database should be saved. Press "Create" to save the database.

The widgets database will be saved, and a new window will subsequently appear. This window will be very similar to the one shown in Figure 1-4.

Figure 1-4: New database window

At this point, the MySQL database can be connected to via ODBC, and its structure and contents updated to the widgets.mdb Access database. Since this particular step is often the cause of confusion for those users attempting their first connection between MS Access and MySQL (or any other database), a separate section is devoted to it.

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

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: