How to connect php file to ms access?

PHP to MS Access help. thanks.?

  • Hi, I have php document on a server. This document should connect to a MS Access database and store a record. I cannot get it to work. How do I get the php to send the data into the access database? Thanks.

  • Answer:

    first you need to make sure your PHP server has the correct modules to connect to Access. Be sure that you have the ODBC module. The look at the site below for a quick tutorial.

WYSIWYG at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

PHP doesn't have native MS Access capabilities, but it does have ODBC capability, which is almost the same thing. It'll just be a bit of a performance hit. In any case, you have to create a DSN (Control Panel -> Administrative Tools -> Datasources) Then you'd use the built in PHP ODBC functions (odbc_connect, odbc_exec) to work with the datasource.

use SQL command to connect, write, read and execute MS db.

....

mind showing your existing code? it basically works with sql statements but im guessing you have more problems than that also access is bullshit, if you are learning php i suggest you scrap the access and use mysql instead, in real world programming almost nobody uses access, certainly not for websites(where php is mainly used)

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.