Hey All,
I want to know if PHP can connect to a MS Access 2002 Database? If it is possible what is the script to connect PHP to MS Access?
Regards, Matthew Byrne
odbc functions or for more links, check google
Cgraz
Ive recently completed a project with the two.
It can be done....but I advise its not a happy marriage. You loss functionality in the databse abstration layer with php. Its slow because your queries go via ODBC and basically from personal expierence Access gives me the kreeps.
My personal thoughts 😃
Hope that helps
I am trying to do a similar project like yours. What do you recommend to me? I appreciate your help. Cheers
Originally posted by JakesSA Ive recently completed a project with the two. It can be done....but I advise its not a happy marriage. You loss functionality in the databse abstration layer with php. Its slow because your queries go via ODBC and basically from personal expierence Access gives me the kreeps. Hope that helps
use ODBC functions...ummmm..
$conn = odbc_connect("your_db_ODBC_DSN_Name", "USER", "password"); $query = "select * from table_name"; $result = odbc_do($conn, $query);
PHP+ACCESS not a good choice!