[AccessD] Access and MYSQL

Hi Darren,

Yes, I have done this a couple of times.

You need to install a MySQL ODBC driver, which is a free download - I 
can dig out details if you can't find it.  When I did it, I created a 
DSN on the client machine, which is easy.  It is possible to do a 
"DSN-less" connection, but I have no experience with that.

After that, the MySQL tables can pretty much be treated the same as any 
linked backend tables.

Regards
Steve


Darren D wrote:
> Hi Team
> 
> Does Access 'connect' to MYSQL?
> 
> If so are there any major gotchas?
> 
> Never done it before and have never even seen a MYSQL dB so it's all new to me
> 
> Will be doing it in the next month or so if Access Connects to it