does anyone here know of any connection strings or relevant drivers I need installed in order to do this? I’ve got a pretty unique situation where I have an ms access database that must be stored on a local machine and connected to via PHP code on a webpage. does anyone know if this is even possible? I’ve searched for quite a while now but have not found anything, although some solutions have come close.
thanks.
It’s possible, but not fun.
https://www.connectionstrings.com/microsoft-access-accdb-odbc-driver/
You will need to set up port forwarding on the router to direct requests to the computer holding the Access mdb, but PDO should be able to handle the querying.
thanks astone. I called my hosting provider too, and made sure that all of the extensions were turned on for PDO and ODBC, in case that was relevant. which I believe it is. I’ll get back to you if I have issues.