Operation must use an Updateable Query

date

2007-08-14 17:47

author

geographika

category

bugs

slug

operation-must-use-an-updateable-query

status

published

I know I see this error about once a year and can never remember the cause, so I’m writing it down this time!

In my case it has always been related to SQL queries and Access databases. Check the following if your SQL command produces this error when executed:

  1. The database is not read only - Visual Source Safe can often be a culprit in setting this property..

  2. The SQL query may contain fields that are reserve words (e.g. DATE, TOP etc.). These should all be renamed in the database (I normally add an underscore at the end).

  3. Go through a long and tedious process of which Windows user is running the SQL (ASPNET, IUSR_COMPUTERNAME etc.) and check thy have write permissions to the folder containing the database, and the database file itself. Remember Access needs to create those pesky .ldb lock files..

orphan


Comments

http://www.gravatar.com/avatar/6b97148b07e119f6793e1a216e9c5b2c?s=55&d=identicon&r=g

1. Israel **

Greatings!

Could you Help me, plese?

I have a dude about off a missing Library from MSSQLSpatial Data, I’m searshing for the complementoff the sql server data Spacial (geography and geometry) for the command OGR for console, cold you sendme the step or links, about this?

a lot to thanks!

Reply
Add Comment