We help IT Professionals succeed at work.

can I use vb for apps as a programming language with mysql database. What language is most common?

Patricia Timm
on
Can I use visual basic for apps with mysql? I have worked with access and am new to mysql. In access I could code in vb to perform a task. I am not sure if I can do this in mysql.
Comment
Watch Question

David Johnson, CDSimple Geek from the '70s
Distinguished Expert 2019

Commented:

mysql has its own query language based upon sql 

In access you have a front end gui and a backend database. Mysql is simply the backend. 

Author

Commented:
What is normally used as a front end? Webbased? How are reports generated as the front end in access allowed you to design reports. Thanks in advance
Simple Geek from the '70s
Distinguished Expert 2019
Commented:

Author

Commented:
Great did not know that! Thanks for link. Why wouldn't someone just create the database in Access entirely as it provides a front end and backend? Why would someone create mysql database when it does not provide a frontend? Perhaps it is more robust as a database? or better with web apps? Thanks for your thoughts
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019
Commented:

MySQL as others Database Engines boast a number of advantages compared to Access.

At first it doesn't have any file size limitations so no more 2GB limits..then its a server "product" optimized to work as a server and scale up ...so you need more power simply switching to a more powerful machine will give you instantly Power.

It also boast true SQL support with all the bells and whistles that comes with it.

Of course these come at a price as this means that you will probably have to invest some serious development time in order to get the best of 2 worlds( Access + MySQL)...there is a never ending argument here (and of course pretty much every other similar site) on how to use them as there are 2 paths.

  • Path1 : The Access "way" ...you simply link the tables via ODBC and presto you have MySQL BE...but is slower and you are not taking advantage of MySQL power...MySQL is used as a "dummy"replacement for Access BE...so no utilization of its power.
  • Path2: The MySQL "way"...you work solely with Pass Through queries and Stored Procedures/Views...it will get you the absolute best performance as you talk directly to MySQL and its doing all the hard work for you...downside...a lot of code changing not to mention the philosophy change...you are not thinking any more in the Access ecosystem and you have to start thinking in terms of MySQL and how to get the least possible data...(but the processing power is greatly rewarding)

If you want to have a quick view of how Access + MySQL works together i have uploaded a small sample application (very early copy) in DropBox and some "instructions" on the last post of this thread

For MySQL the connection string is :

ADO : Driver={MySQL ODBC 5.3 UNICODE Driver};Server=Ip/NameOfServer;Database=NameOfDatabase;User=Username;Password=Password;

DAO : ODBC;Driver={MySQL ODBC 5.3 UNICODE Driver};Server= Ip/NameOfServer ;Database= NameOfDatabase ;User= Username ;Password= Password ;OPTION=3

Here is a small video of an older version of the application pulling data over the Internet (Cloud MySQL) : https://www.linkedin.com/posts/tsgiannis_a-small-demo-of-connecting-ms-access-fe-to-activity-6392696633531858944-dsuU

Side Note: Regardless of the above Access is a terrific tool...able to put to shame a LOT of rivals either as desktop application platform or a database engine...the only real issue is the lack of "Remote Access' like the SQL Engines (port) but in many cases there are "workarounds"

Author

Commented:
Thanks for the clarity on performance between the two. However, I am still not sure what front end one would use if mysql is on the back end. What front end would you use to create reports and forms? Is mysql used as a backend to plug into multiple front ends maybe web based? Can mysql stand alone to offer reports or front end forms for the end user? The data in this mysql database needs to be manipulated to generate reports and forms for the end user. Thanks again for helping me learn more.
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
MySql is Database.. BE ...for FE you can use everything that can connect to it
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
Access is a complete all around solution without a need for anything "extra"

Author

Commented:
Thanks