Updating The Database - MySQL

Figure 1-7 shows a simple GUI created using the MS Access Form Wizard. After creating this GUI, I used it to insert a sample record into the database.

Figure 1-7: Clients GUI



Create a GUI similar to the one shown above, and experiment with inserting information into it. Immediately upon doing so, connect to the MySQL database and execute a select * query on the clients table. The table will show that it has been updated with the information entered using the MS Access GUI! Figure 1-8 shows the clients table as seen from MS Access after entering one record. Following Figure 1-8 is a view of the MySQL clients table after executing a SELECT * query.

Figure 1-8: View of the clients table from MS Access

mysql> select * from clients; 
+----------+-----------------+-------+------------+----------------------------+
| clientId | name            | state | telephone  | email                      |
+----------+-----------------+-------+------------+----------------------------+
|        1 | Widget Fanatics | OH    | 4125555678 | widgets@widgetfanatics.com |
+----------+-----------------+-------+------------+----------------------------+

To convince yourself that the synchronous updates occur regardless of whether the update takes place from MS Access or directly from MySQL, go ahead and delete the newly added row from within the MySQL monitor. Then return to MS Access and reopen the clients table. You will see that the data has disappeared!

For those readers new to MS Access, take some time to experiment with the various Wizards made available from within the program. Using these Wizards will better acquaint you with how Access works. However, to tweak the various components of the Access interface to your specific needs, you will need to learn how to modify the component properties manually. To learn more about doing so, I would suggest searching the Web and consider purchasing one of the many books available on the subject.

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

blog comments powered by Disqus