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