Google Answers Logo
View Question
 
Q: Using MS Access with MySQL ( No Answer,   3 Comments )
Question  
Subject: Using MS Access with MySQL
Category: Computers > Programming
Asked by: awilson1776-ga
List Price: $10.00
Posted: 22 Apr 2006 19:37 PDT
Expires: 22 May 2006 19:37 PDT
Question ID: 721847
I am getting an error when I try to link MS Access XP to MySQL.

I have installed the ODBC drives for MySQL that I just downloaded from
the MySQL website, when I create the Datasource Name and give it the
parameters it lists the databases in the Database list and when I test
the connection it works, but when I click OK it gives me a Microsoft
Office Access error box.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Using MS Access with MySQL
From: lonecrow-ga on 22 Apr 2006 19:57 PDT
 
Can you post the error message please.
Subject: Re: Using MS Access with MySQL
From: awilson1776-ga on 23 Apr 2006 10:22 PDT
 
It is a common Windows Reporting error (to report the error to
Microsoft). The specifics are

Code: 0xc0000005
Flags: 0x0000000
Record: 0x0000000000000000


Not much help, I looked all over the internet and the Code: 0xc0000005
seems to be a generic error.
Subject: Re: Using MS Access with MySQL
From: cmsesan1-ga on 27 Apr 2006 18:41 PDT
 
You may be best to convert the Access database to MySQL and import it
into MySQL as I have done in the past.

You can download the tool to convert the database from here:
http://www.download3k.com/Access-to-MySQL/Download-Free-acc2sqld.exe.html

Then use web forms and PHP code to modify the database from your web browser.

Hope this helps.


Ed

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy