From Access Database to MySQL

[mikejaytlabustro]

Greetings!
I have learned and able to develop MS Access program from Tables, Table Relationships, Normalization, Forms, Queries, Reports, Data Outputs and so on.. I can get what I want on Ms Access so far, but this time I am interested to try MySQL Database. Creating tables and some basic queries in MySQL is quite simple because i already have a background in MS Access. Unlike MS Access Forms and Reports are already included and not so complicated to use. I would like to ask if what is the best software to use for MySQL Database?

 

[John.Woody]

You can attach your MySQL tables to an access database and create your front end in Access, however I think most people would use php to create web pages and build an app to work via a web browser.

 

[zpy2]

VB.net also available for MySQL.

 

[pbaldy]

FYI, thread moved from SQL Server forum since it's not related to SQL Server.

 

[HiTechCoach]

Greetings!
I have learned and able to develop MS Access program from Tables, Table Relationships, Normalization, Forms, Queries, Reports, Data Outputs and so on.. I can get what I want on Ms Access so far, but this time I am interested to try MySQL Database. Creating tables and some basic queries in MySQL is quite simple because i already have a background in MS Access. Unlike MS Access Forms and Reports are already included and not so complicated to use. I would like to ask if what is the best software to use for MySQL Database?

Did you now Access really is not a database. Is is a front end. By default is uses the the JET (.mdb) or ACE (.accdb) database engine.

If is possible to use the tables in a JET or ACE database without Access. You coudl use VB6, .NET or other development platforms to read and write to JET (.mdb) or ACE (.accdb) database formats.

To be able to use anything other than the tables you do need Access installed.

Access can be used as a front end to many other databases. It is commonly used with MS SQL Server. It can also by used with mySQL or any database that you have the ODBC drives installed.

I have used Access as a front to for both MS SQL Server (full and the free Express) and also mySQL. I find that Access has better built-in support for MS SQL Server. I also find that the free MS SQL Server Express perform better than mySQL installed on Windows.