connection to ms access database via mysql

[rosesau]

this is a short question does mysql support access to a ms access database. if so do i need to make changes to my access 2000 database. if i do need to make changes to that database what and how do i make those changes?

thanks

rose

 

[tlbroadbent]

MySQL provides an ODBC driver that can be used to link MySQL tables in an Access ddatabase. It appears that MySQL cannot import from or export to MS Access directly. However, I'm not knowledgeable about MySQL and can't state this is definitely so.

You can search the MySQL web site for more answers and download MyODBC.

http://www.mysql.com/

Terry

;-) He has the right to criticize who has the heart to help. -Abraham Lincoln

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm