Error Message in PHP while connecting to Access Database!!URGENT

quest14378

I am new to PHP and need your help.

I am trying to execute the SQl command in PHP and am getting the error.

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in E:\Portalwebsite\OtherDB\phpcode_addition.php on line 55

The code that is causing problems is:

$result= odbc_exec( $db, $query );

$query1 = "Insert into Reference (Reference_Type) values ('".$Reference."')" ;

$result1= odbc_exec( $db, $query1 );

toma42

Can't say for sure, but this:
$result= odbc_exec( $db, $query );
is suspicious only beacuse you didn't provide the $query above. If it's empty there's a chance, I guess, you may, perhaps, get that error message.

Disclaimer: I don't use access and this is only a guess

quest14378

Thanks for trying to help....its much needed

The complete code for this part of the problem is :

$query = " INSERT INTO RefDetail (RefDetail_AuthorLastName,RefDetail_AuthorMiddleInitial,RefDetail_AuthorName,RefDetail_Title,RefDetail_ReferenceName,RefDetail_Multipltauthors,RefDetail_Publisher,RefDetail_Abstract,
RefDetail_Year, RefDetail_Volume, RefDetail_Issue,RefDetail_InitialPage, RefDetail_NumberofPages, RefDetail_KeyWord1, RefDetail_KeyWord2, RefDetail_KeyWord3, RefDetail_KeyWord4 )VALUES

( '".$AuthorLastName."','".$AuthorMiddleInitial."','".$AuthorFirstName."','".$Title."', '".$Source."', '".$OtherAuthors."' , '".$Publisher."' , '".$Abstract."' , '".$Year."', '".$Volume."' ,'".$Issue."',
'".$InitialPage."', '".$NumberofPages."' ,'".$KeyWord1."' ,'".$KeyWord2."' ,'".$KeyWord3."' ,'".$KeyWord4."')";

$result= odbc_exec( $db, $query );

$query1 = "Insert into Reference (Reference_Type) 
			values ('".$Reference."')" ;

$result1= odbc_exec( $db, $query1 ); 


if ($result) 

{

echo (ODBC_affected_rows(). " Details inserted into database.");
}

if ($result1) 
{

echo (ODBC_affected_rows(). " Reference inserted into database.");
}

The server does not have access installed though it has the database copied on into it for me to make changes. Does that matter?

Thanks again