How to revise the attached MS Access db to MySql db?

Posted on 2012-04-10
Last Modified: 2012-04-10
Dear EE experts,

We would like to ask for tech support on how to revise the attached ms access file into mysql db. We need to change our db to mysql as our host doesn't support MS Access, and we need to connect that db with our PHP & ASP files...

Please see the attached file...

Thank you & hope to hear soon...
Question by:Stiebel Eltron
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 24

Accepted Solution

johanntagle earned 500 total points
ID: 37830988
I haven't used it but MySQL Workbench has a feature to help you convert/import an access database., among other pages on the web, seems like a good starting point for you.

Author Comment

by:Stiebel Eltron
ID: 37831032
Hi there johanntagle!

We need to convert that in order for us to use it to our GoDaddy host. That only supports MySql & SQL Server (for our chosen host plan).
LVL 24

Expert Comment

ID: 37831037
Then try converting it using the instructions in the link I gave you.
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users


Author Comment

by:Stiebel Eltron
ID: 37831039
Will it work with Windows 7, 64bit system?
LVL 24

Expert Comment

ID: 37831050
Looks like MySQL Workbench only has 32-bit installers but why not just find out for yourself?

Author Comment

by:Stiebel Eltron
ID: 37831099
Ok, will do... thanks!

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

623 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