Solved

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

Posted on 2012-04-10
6
372 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to count occurrences of each item in an array.

744 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

14 Experts available now in Live!

Get 1:1 Help Now