Solved

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

Posted on 2012-04-10
6
400 Views
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...
products-asia.mdb
0
Comment
Question by:Stiebel Eltron
  • 3
  • 3
6 Comments
 
LVL 24

Accepted Solution

by:
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.  http://www.hosting.com/support/mysql/amconversion, among other pages on the web, seems like a good starting point for you.
0
 

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).
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 37831037
Then try converting it using the instructions in the link I gave you.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

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

Expert Comment

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

Author Comment

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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

827 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