[SOLVED] php with access

[loving_php2008]

i want to insert data from php to microsoft access ,but i got warning..

 

 

its the error that i got

 

PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\wwwroot\php\test.php on line 8 .

 

and its the code:

 

<?php

$conn=odbc_connect('test','root','');

if($conn)

{

echo "connect";

}

$sql="insert into t1 values(1,'emmy')";

odbc_exec($conn,$sql);

?>

[loving_php2008]

i think there are changing in permission....

[DeanWhitehouse]

That might be the problem, the file may be read only try changing its permission. And please stop bumping this thread.

[loving_php2008]

this site is for help....ok..

[DeanWhitehouse]

Yes, but the help is voluntary so stop bumping ,we are not paid and we do not have to help if someone knows the answer they will post it, bumping just annoys people.

 

[loving_php2008]

hi all...

 

PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\wwwroot\php\test.php on line 9

 

<?php

$conn=odbc_connect('test1','','');

if($conn)

{

echo "connect";

}

 

$sql="insert into t1 values(10,'meme')";

odbc_exec($conn,$sql);

 

?>

 

in fraction i solved the problem,when i make share of the folder that contain the access database...

its work well....