Find solution
How to enable MySQL remote access?

MySQL vs. MS Access?

  • Is there a big difference between Access and MySQL? I'm learning Access in a class but will need to know MySQL later for a web project. Will it be hard to learn MySQL after ...show more

  • Answer:

    For the most part transitioning wont be that huge, MySQL is much more powerful, but Access is much more mobile. They both use the SQL language. That is of course if you're talking about using them for programs, if you're talking about using front ends, MySQL doesn't really have one, at least not one that is user friendly. You'll need a piece of software over the top of that to make it friendly like Access (... as friendly as it is...). Personally I've only ever used Access as a database like MySQL, I forget it has a fancy front end for database management.

D4RDFMIIYHYSEY32NME6IZMZ2I at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Access is a program more like Word. You start access and open files in it. Mysql is not a program that you use to open and view a database. It is a server that sends the data to a client. Mysql is built around a client/server model.

DanCorb

Are you learning Access, or are you learning SQL? Knowing how to make Access work has nothing to do with knowing the SQL language, which is what you'll need for just about any other database, including MySQL. At least study the SQL panel for every query you learn, until you can do all your queries directly in SQL - MySQL has no drag&drop facility to build queries with (although you can still build them in Access and copy the code to whatever you're using for MySQL)..

mysql is designed for websites using php as a possible interface for logging into the mysql server, a lot of sql is wrote in command lines rather than a graphical click and point interface like msaccess there are tools out there than can speed up writing queries but most are not free.

Paultech

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.