Page 1 of 1

delete record from COM("ADODB.Connection") dbase

Posted: Wed May 19, 2004 1:38 pm
by bartemannekes
$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.

Posted: Wed May 19, 2004 2:10 pm
by Weirdan
shouldn't the line:

Code: Select all

$query = "DELETE * FROM users WHERE id=1;";
be

Code: Select all

$query = "DELETE FROM users WHERE id=1;";
?

Posted: Wed May 19, 2004 3:22 pm
by bartemannekes
I've been told that msaccess can't handle the form you propose.
Anyway, your solution does not solve the problem.

B

Posted: Wed May 19, 2004 3:47 pm
by Weirdan
They were lying to you ;)

Just checked such a query with Access 2003 on Access 2000 database. Worked like a charm. So your problem seems to be in ADODB, not in SQL query I proposed.