MySQL - Visual Basic Project Documents

The documents available from this page are from a group project in a client-server class at a local university. (Evening class: two group members working, the other unemployed.)

The professor offered the option of creating a client-server application in lieu of taking the final exam. Since the presentation date for the project was two weeks before the final exam date, creating a simple application made more time available for studying during finals.

The database interface used is ODBC, which isn't cutting edge but was a topic of interest to the professor.

The project has a simple VB6 frontend to a MySQL database on a separate server. ODBC also allows for easy access from the MS Office suite (Word, Excel, Access) which was also a part of the presentation - filling out form letters and generating charts from the same database used for inventory.

The PowerPoint presentation is very brief, but has screen shots of some of the MySQL and ODBC configuration screens.

The Word document is very detailed and includes the source code for the application, screen shots of most of the ODBC access from Office, and links to MySQL and ODBC related sites.

I mentioned the existence of these documents in one of the Visual Basic newsgroups and was asked to make them available to other people who are interested in using MySQL with VB.

You can download the documents here.

PowerPoint 97 presentation

Word 97 document

The Excel spreadsheet that extracts data from the database and draws a graph. It provides the option of selecting the MySQL server by name or IP address. It's all done with VBA code.

The merge file for Word. This expects to find a MySQL server named "jecntws" on the network. You must have MySQL running (on your PC or a server on the network) and you must setup ODBC on your PC and edit the DSN's in the code to match your configuration.

The development directory (includes multiple versions) is a 220K zipped file. This code also expects to find a MySQL server named "jecntws" on the network. You must have MySQL running (on your PC or a server on the network) and you must setup ODBC on your PC and edit the DSN's in the code to match your configuration.





If you want a tutorial on installing and using MySQL, try http://www.analysisandsolutions.com/code/mybasic.htm


If you find any of this information useful, please consider donating $2.00 (via PayPal) to help support these pages.

Think it's worth more than $2.00? Send something from my Amazon wish list.


Home page | Programs


Last update
This page is mysql.html
Copyright © 2002-2007 John E. Carter All Rights Reserved