[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Access DB to mySQL conversion

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?
0
szadroga
Asked:
szadroga
2 Solutions
 
Randy DownsOWNERCommented:
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.

http://dbconvert.com/convert-accessforms-to-web-mysql.php
0
 
mankowitzCommented:
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 http://www.mysql.com/why-mysql/white-papers/mysql_wp_access_visual_guide.php
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now