situation 
i have a web application run smoothly in a windows 2000 os
with office 97 installed, php 4.2.2 installed.
i just got another new computer with win2000 also and installed with office 97 and php 4.2.3
i want to set this comp as backup server.
after i copy all my app file and the php.ini file to the new pc, the application can only show the record set but can update, delete and adding new records to the database.
i use the script below to test in the two computer,
RESULT
pc with php 4.2.2
ok with add, update, delete and view recordset
pc with php 4.2.3
ok with view recordset,
fail to add, update and delete
my advice
don't install php 4.2.3,
it seems that it contains some bugs against the Microsoft office...
or ADODB or .... whatever...
<?
include("../cls/onliwill.onli");
include("../cls/onli_db.onli");
function rs_view($rs){
while(!$rs->eof){
echo $rs->fields["ID"]->value;
echo " ";
echo $rs->fields["ANAME"]->value;
echo "<br>";
$rs->movenext();
}
echo "<hr>";
}
$db = new onli_db();
$conn = $db->db_open("db1.mdb");
//
$sql = "select * from account";
$rs = $conn->execute($sql);
rs_view($rs);
$rs->close();
// +----+
// | ok |
// +----+
//
/
echo "updating";
$sql = "UPDATE account SET ANAME='updated value' WHERE ID=2";
$conn->execute($sql);
// +--------+
// | failed |
// +--------+
//
/
echo "deleting";
$sql = "DELETE FROM account WHERE ID=2";
$conn->execute($sql);
// +--------+
// | failed |
// +--------+
//
/
echo "add";
$sql = "INSERT INTO account (ANAME) VALUES ('new add value')";
$conn->execute($sql);
// +--------+
// | failed |
// +--------+
//
?>