Solved

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

Posted on 2012-04-10
6
389 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

770 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