Hi,

I am new to PHP, i got how to connect to the MS-ACCESS Database and retrieving data, but when i try to insert it is giving some error message.
How resove it? Can any one help out......?

hi,
here is the basic connection code

<?php
$db_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Northwind.mdb").";";
$db_conn->open($connstr);
$rS = $db_conn->execute("SELECT * FROM Employees");
$f1 = $rS->Fields(0);
$f2 = $rS->Fields(1);
while (!$rS->EOF)
{
    print $f1->value." ".$f2->value."<br />\n";
    $rS->MoveNext();
}
$rS->Close();
$db_conn->Close();
?>

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com