note 64411 deleted from faq.databases by philip

Note Submitter: Kaleabtesfaye at hotmail dot com ---- If Some1 is intersted on PHP with MS Access here is some code <?php $db = 'C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb'; $conn = new COM('ADODB.Connection') //or exit('Cannot start ADO.'); // Two ways to connect. Choose one. $conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.'); //$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") //or exit('Cannot open with driver.'); $sql = 'SELECT Table Field1,feild2... FROM db ORDER BY Field'; $rs = $conn->Execute($sql); ?> Enjoy Addis Ababa, Ethiopia