Question: Operation Must Use an Updateable Query

[SheryMich]

Hi -
I am having a bit of a problem with the insert into a database. When I go
to insert a record into an un-keyed, single table Access database, I get the
aforementioned ''Operation Must Use an Updateable Query' error.

Points:
- The database is in my local temp directory, not inetpub
- The directory has read/write permissions
- The database has read/write permissions
- I created another version of the dbase and tried to reference it with the
same result
- I can access the dbase and sucessfully select rows from the database to
populate a datagrid

Other points:
- Database sucessfully opens and closes
- IIS was installed after the VB.net code. I re-ran gacutil to re-register
dlls

Code Snippet:
Dim mSQL As String = "INSERT INTO Messages(LastName, FirstName,
EmailAddress, MessageDate, Message) VALUES ('Smith','John',
'(e-mail address removed)','10/26/2003','stuffs')"
Dim objCmd As New OleDbCommand(mSQL, cn)

Try
objCmd.ExecuteNonQuery()

Catch ex As Exception
Label.Text = ex.Message

End Try

I am not sure at this point whether this is a VB or ADO issue. Any thoughts
or suggestions would be greatly appreciated.
- Sheryl

 

[William Ryan]

Check out this link.. there's a Knowledgebase article about
this...http://www.dotnet247.com/247reference/msgs/14/74813.aspx

However, can you fire any updates, insert or deletes? Basically, will this
query definitely run if you do it from within access? If you were using a
CommandBuilder or DA Configuratino wizard, the problem would probably be the
lack of a key, but that doesn't appear to be the problem. If you are sure
the query will run, then the link above is the most likely solution.

HTH,

Bill

 

[Bob]

Hiya,

You say the database and the directory it is in have read/write access...
but for who? If you are running the ASP under the default IIS account you
will need to explicitly set permissions for that account on the file and
folder. By default the IIS account (IUSR_ComputerName) has permissions to
bugger all.

Even if you are running the ASP under a user account you will still need to
ensure it has permissions but the IUSR account is very limited so least
likely to work by default.

Also, you don't show how you open the database so we have to assume you
didn't open it read only...

Try these search results for more info:

http://search.microsoft.com/search/...n+Must+Use+an+Updateable+Query&qa=&qn=&c=&s=0

Cheers