Operation must use an updateable query

Anon

Hello!

For some reason, running this script, I get the error message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect

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

$query = "INSERT INTO table (field1, field2, field3) VALUES ('$field1','$field2','$field3')";

odbc_exec($conn,$query);

I've made scripts like this a thousand times before. What is wrong???

Anon

I got the same error because the file had read only permissions.

try going into explorer, select the database file, right click to select properties, security. In there highlight user-everyone and check the write box - worked for me....

found this as well

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

Anon

I have a solution as well.

This error message plagued me for hours.

Every FAQ I read dealt with permissions. The 3 other databases in the directory updated and "inserted into" just fine.

I reduced the darn database to one record with one field and still got the message.

I checked permissions on the database. I checked the permissions on the server. I even checked my drivers license for permissions.

Finally, out of sheer frustration, I made a copy of the database on my desktop, deleted the one on the web, and uploaded the new copy of database from my desktop to the web.

It now works just fine. Beats the heck out of me what happened (or even what I did), but my advice is to export the data from the db into a new fresh db, destroy the original, and copy the new one.

Anon

Thanks David, I don't believe I spent 4 hours trying to work out the permissions when all I had to do was take a new copy of the database!!!!

Saved me a bit of time at least

David Dalebroux wrote:

I have a solution as well.

This error message plagued me for hours.

Every FAQ I read dealt with permissions. The 3 other databases in the directory updated and "inserted into" just fine.

I reduced the darn database to one record with one field and still got the message.

I checked permissions on the database. I checked the permissions on the server. I even checked my drivers license for permissions.

Finally, out of sheer frustration, I made a copy of the database on my desktop, deleted the one on the web, and uploaded the new copy of database from my desktop to the web.