This document presents information, tips and suggestions for making the conversation based on the experience of staff at the University of Kentucky College of Education Database and Information System Project.
1. Why Mysql?
2. Exporting an MS Access Database to MySQL
3. Useful Websites
4. Using Access as a client with mySQL
5. Some other useful tips
6. Installing MySQL drivers
7. Installation
Mysql Useful Tips (Doc)
By. Bharath K R & Vinay Srivastava
ukdame.coe.uky.edu/dameportal/documents/
MySQL is a relational database management system (RDBMS) that provides users with a powerful multi-user, multi-threaded SQL (Structured Query Language) database solution. It is fast, robust, and easy to use. Information system managers who oversee MS ACCESS database systems that are beginning to show their age may wish to consider converting their ACCESS files to MySQL files. Data moved to MySQL can continue to be accessed using already-developed ACCESS queries, forms, and reports.NOTE: By downloading the software from this page, you acknowledge that the software available from here is licensed under the GPL. We advise that you review the GPL before downloading.
MySQL Connector/ODBC 3.51.16 (Win32)
Select other OS and Mirror Download click here
http://dev.mysql.com/downloads/
It contains information on events ,methods ,objects ,properties,constants, data types, directives, events, functions, group, indexes/lists, keywords, methods, misc, objects, operators, statements and complete chart help with every property and method explained. Everything you ever wanted to know about Visual Basic.
Complete Commands.zip
fullnotes saqib sajjad's VB page
BackgroundSMS or Simple Messaging Service is a means of sending a short message (160 characters max) to another SMS capable device via the GSM network. On Pocket PC Phone edition devices and Windows CE Smart phones, when selecting a folder, there should have been at least an ActiveSync and SMS message store and possibly an MMS message store as well.These message stores hold messages from different transport providers locally on the device.For the purposes of this article, we will be concentrating on the SMS message store as we want to use this to send a message.Using the codeTo make the code simpler and easier to understand, the bulk of the code uses MFC for the User Interface and ATL for smart pointer support.If people request it, I may make a Win32 only version available as the relevant code (i.e., not the UI code) only requires ATL and not MFC.In this article, I am not going through a listing of the creation of the MAPI session and opening of the SMS message store and outbox folder. The code is well commented and provided in the source zip file in the two functions GetSMSMsgStore and GetSMSFolder which get the relevant SMS message store and the SMS drafts folder.
Note: If you have not got a Pocket PC Phone Edition or Windows CE SmartPhone device, sorry this article will not be useful.
Fullnotes: codeproject.com
Language Support: HTMLAPI: SMS Web Service HTTP APIDescription: HTML Form to send an SMS message using the SMS Web Service HTTP APIContributed By: Connection Software
[ Download source code ]
(required an account from csoft.co.uk)
