0

Does anybody know if it is currently possible to remotely connect to a MySql server from MS Access? What does one need to do to go about doing this?

1 Answer 1

1

Yes, by using linked tables. Here's the MySQL documentation https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html

Add a User DSN from the ODBC Data Source Administrator, testing the link to your MySQL database to ensure you have the server, user name and password correct.

In Access on the External Data tab select ODBC Database. Choose the Link... option. Select Machine Data Source and the name of the DSN you set up. The tables available will appear. Choose the one(s) you want and click OK.

5
  • That only works on a local connection. I want to know how to configure a remote connection to a MySql server,
    – Madrigone
    Apr 14, 2016 at 22:14
  • 1
    No it doesn't. I just set up an ODBC user DSN to a hosted MySQL database and linked to it via Access.
    – tpet
    Apr 14, 2016 at 22:19
  • Could you go into more detail about how you did this?
    – Madrigone
    Apr 14, 2016 at 22:20
  • @Madrigone - Did you look at the details in the link provided?
    – Hannah Vernon
    Apr 14, 2016 at 22:23
  • Sure, I've updated the answer with a bit more detail. Hope you can get this working.
    – tpet
    Apr 14, 2016 at 22:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.