[thelist] Error: Operation must use an updateable query.

Casey Crookston casey at thecrookstons.com
Wed Dec 29 22:02:28 CST 2004

When attempting to insert into, update, or delete rows of an access
database, I am able to do so on my local development server.  But when I
upload to the production server, I get this error.  I checked permission on
the database and set them accordingly, so I don't think that's the problem.
I'm out of ideas.   Again... it works just fine on my local server.

Anyone?  Thank you!

Casey, who's one error away from completing this project and getting paid.

Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use an
updateable query.

Source Error:

Line 59: 		myAddMemberCmd = New OleDbCommand(sqlString, myDbConn)
Line 60: 		myDbConn.open()
Line 61: 		myAddMemberCmd.ExecuteNonQuery()
Line 62: 		myDbConn.close()
Line 63: End Sub

Source File: E:\Inetpub\wwwroot\SaintPaulRotary\change\directory_add.aspx
Line: 61

More information about the thelist mailing list