I have a Linux-based web server running with the LAMP package. For security reasons, the sever only allows logins via SSH and denies regular password login attempts. I want to use the MySQL ODBC driver within Microsoft Access 2016 to connect to this server for data analysis purposes, but I do not see an option in the ODBC Data Source
Tag: ms-access
Connect to remote MS Access database from Linux Server using PHP
Does anyone know if it’s possible to connect and query an MS Access database from a Linux Server using PHP? If it is possible I’m thinking install ODBC driver on the Linux server, but will it work to connect to Access is the question. I’ve read it’s possible with MSSQL. My knowledge is very limited when it comes to any