Use MS Access to get the data from a server database

[jamest85]

I have no experience using MS Access to interface with MySQL.
I have a tiny MySQL database that might need to have Access connect with it
over the internet and grab data/update etc.
Is this practical and what does it take to do it?

My project is not time sensitive but I'd like to see what methods I can use
to do remote queries with my database running on a server.


Thanks

 

[Banana]

To communicate with MySQL, you will need MyODBC (you can download this for free from MySQL's website; look under Connectors/ODBC). The current version is 5.1 though 3.21 is still supported.

You said over the internet. You can use TCP/IP. If you have sensitive data, y ou can use SSL functionality which is built-in with MySQL, provided you already hold an certificate.

You can link the tables which is by far is the easiest way to access data with MySQL. There should be guides for linking to ODBC tables on MSDN.

HTH.