Access Database - Insert - Auto Number

[kerriejones]

I am a bit rusty with my php, but I need to move some code on to a new website and coming upon a lot of problems. This one I can not solvefor the life of me.

I am trying to insert a record into a table which has an auto number as the key. I was not sure if my connection was the problem so I tried the following select first, but it runs withput any problem:
$mySQL = "SELECT * FROM Audit Where AuditID = 1089";
$resNews = $conn->execute($mySQL );
if (!$resNews->EOF)
{
$display = $resNews->Fields['AuditMessage']->Value;
echo $display;
}


Then I attempt an insert:
$sqlAudit = "INSERT INTO Audit (AuditType,Audi tCust,AuditMess age) VALUES('LOG','9 99999','Success ful login');
$conn->execute($sqlAu dit);

I get the following error
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description :</b> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.' in C:\Tardis\Plumb ers_Supplies\fV alidate.php:246 Stack trace: #0 C:\Tardis\Plumb ers_Supplies\fV alidate.php(246 ): com->execute('INSER T INTO Aud...') #1 C:\Tardis\Plumb ers_Supplies\fV alidate.php(55) : GenerateAudit(O bject(com), '999999', 'LOG', 'Successful logi...') #2 C:\Tardis\Plumb ers_Supplies\Va lidate_Login.ph p(8): CheckLogin(Obje ct(com), '999999', 'bill', false, Object(com)) #3 {main} thrown in C:\Tardis\Plumb ers_Supplies\fV alidate.php on line 246

[stepterr]

I would start by checking what the permissions are. It could be that you have read permissions on the database and not write permissions.

[kerriejones]

Thank you - that was my problem!