update sql statement for access

[sandman]

Having trouble getting the following update sql statement to work:

function Enter_New_Entry($Elav) {

$cnx=odbc_connect('customer','root','');
if(!$cnx) {
Error_handler("Error in odbc_connect",$cnx);
}
$SQL_Exec_String="Update ModelChoice
Set Elavation='$Elav'
Where UserID='$UserID'";

$cur=odbc_exec($cnx,$SQL_Exec_String);
if(!$cur){
Error_handler("Error in odbc_exec( no cursor returned)",$cnx);
}

odbc_close($cnx);
}

I don't receive any error messages and it continues onto the next page of the site; however, the access database is not updated with the Elavation. $Elav is being fed from a form on the previous page and $UserID is a session variable.

It has me completely baffled, so any help would be appreciated.

[chriskl]

Well, elavation is usually spelled 'elevation', but I assume that's not the problem. Are you sure Access is not in some sort of auto transaction mode? ie. you might need to send a 'commit;' at the end of the transaction.

Chris