Trying to access a "MySQL" database from MS Access?

[Guest]

I'm wanting to connect to my hosted DB (MySQL) with MS Access to pull
assessment/survey data into MS Access to work with, report, etc. Not having
any success, as the options I have to choose from when I try to connect are
to a SQL db and OLE. Any suggestions?

 

[David Conger [MSFT]]

I believe MySQL provides a tool called "Connector" which allows this to
happen. MySQL has a whole MySQL/Access forum you might want to check out:
http://forums.mysql.com/list.php?65

Of course, if this is you own server, you might consider trying out
something like SQL Server 2005 Express Edition, which is free like MySQL.


--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **