Description:
------------
When ever i try to delete a record with a MS access database I get the following error message

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables., SQL state S1000 in SQLExecDirect in C:\Estates Info System\admin\Delete_Site.php on line 13

I know ther no problem with the sql statment, not sure what to do.

I am using PHP, IIS and MS access

Please Help

Reproduce code:
---------------
<? 
$connect = odbc_connect ("Information_System","root","");
$query = "DELETE FROM Site WHERE(((Site.[Site Code])='076'))";
odbc_exec($connect, $query);

?>

Expected result:
----------------
Record with key 076 whould be deleted but is not

Actual result:
--------------
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables., SQL state S1000 in SQLExecDirect in C:\Estates Info System\admin\Delete_Site.php on line 13