Access DB to mySQL conversion

Posted on 2011-10-05
Last Modified: 2012-05-12
I currently have a pretty simple Access DB that contains employee information that I am going to convert over to a MySQL database.  Currently, i have a form built in Access that contains a few buttons that run Macros in Access (append and delete queries).

Can you build a form within MySQL or can I leverage my existing form?  Also, does MySQL have the abilities to enter macros?
Question by:szadroga
    LVL 29

    Accepted Solution

    MySQL doesn't have forms or macros, it's simply the database. You design your forms in .php You might try a conversion utility like this to get you started.
    LVL 24

    Assisted Solution

    mysql is just the database back-end, and has no graphical user interface (with forms or buttons) as you require. There are stored procedures, which may take the place of your macros, but it is probably simpler just to use canned SQL statements.

    How will users interact with MySQL? Through web page? Are you going to continue to use Access as a front end? MySQL has a whitepaper on that: see

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now