delete record from COM("ADODB.Connection") dbase
Posted: Wed May 19, 2004 1:38 pm
$Hi.
Trying to delete a record from an access database.
It appears that the record never gets deleted. What is going wrong?
$dbcon = new COM("ADODB.Connection") or die("Cannot start ADO");
$dbcon->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("users.mdb").";");
$query = "DELETE * FROM users WHERE id=1;";
$rs = $dbcon->Execute($query);
$dbcon->Close();
$dbcon->Release();
$dbcon = NULL;
Thanks a lot for your help.
Trying to delete a record from an access database.
It appears that the record never gets deleted. What is going wrong?
$dbcon = new COM("ADODB.Connection") or die("Cannot start ADO");
$dbcon->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("users.mdb").";");
$query = "DELETE * FROM users WHERE id=1;";
$rs = $dbcon->Execute($query);
$dbcon->Close();
$dbcon->Release();
$dbcon = NULL;
Thanks a lot for your help.