How to Connect PHP with Microsoft Access Database

How to connect to MS Access database in PHP7?

To get a seamless portable database storage which works with office products as well as server based i suggest to have a look at SQLITE. The database is inside a single file which makes it highly portable between devices. It is open source, supportetd on many OS and has working connectors foe nearly anything possible. In your case you can have for example a fast ado connector in the WAMP server and on Excel and friends a native VBA connector.

Connecting to a MS Access database from PHP on Linux

I found the solution to my problem was removing the ; from the query.

Connecting with PHP script to a remote Microsoft Access database on a Windows 2003 server connected on my LAN

What you need is an ODBC bridge, and to set up an DSN on your windows computer. I've written a previous answer on very similar question, detailing how to go about setting one up.

Adjust the answer accordingly to your PHP server's OS.



Related Topics



Leave a reply



Submit