Reputation: 11
Is it possible to access an online MySQL database in Access 2013?
I have an online MySQL database that I use for the backend to my website. However to get to the database, I have to login to my hosting provider, then log in to cPanel, and then log into phpMyAdmin, which is quite slow to use.
I would like to be able to access or stream the database to Access so I could download, edit and upload sections of it. Is this possible?
Upvotes: 0
Views: 72
Answers (1)
Reputation: 3938
Technically, nothing forbid you to make some linked tables in Access toward an online MySQL database using the Mysql ODBC driver. However, for security purpose, most hosting services will block anything that is not a direct HTML access to a web site at their firewall level. Therefore, you have to ask your provider if such an access is allowed and if yes, what are the connection parameters.
Upvotes: 1
Related Questions
- open a SQL database online without using MySQL
- Using MS Access as a front-end to MySQL db
- Connect Local Access Database to live website
- How to use Microsoft Access database file online for asp.net web application?
- Accessing a Microsoft Access table from a MySQL database
- MS Access to MySQL Connection
- PHP MySQL database from MS Access
- How can i access Ms-Access database using MYSQL Query
- Is it possible to host Access forms online?
- How to get static MS-Access DB online and connect to it using PHP?