problem with datagrid update code

[dbsquared]

i keep getting the error below

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 662:            adpRed.Update(MyDataSet)

I have edit buttons, cancel buttons and ok buttons however the most important one the update button isn't working. Here is my code for the project:

Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpdate.Click
        ' Code to respond to the Click event of the UPDATE button:
        ' Desc: Updates the underlying database, then rebinds.
        ' Add error handling code as appropriate.
        If DataExists() = False Then Exit Sub
        adpRed.Update(DataRetrieve)
        dgRed.DataSource = DataRetrieve()
        dgRed.DataBind()
        cmdUpdate.Visible = False

End Sub
Public Function DataRetrieve() As DataSet
        Return CType(Session.Item("__Data"), DataSet)
End Function

i got the code from

http://www.developer.com/db/article.php/3314411

so if i understand everything right what I have is a session copy of my dataset and I am using that to manipulate my data. i am not sure why it wont update the database any help would be greatly appreciated.


To go where no programmer has gone before.

 

[ca8msm]

Are you using Microsoft Access as the db in this test?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dbsquared]

yes I am is that the problem?

To go where no programmer has gone before.

 

[ca8msm]

Generally, when you get a "Operation must use an updateable query" it's to do with Access and it sometimes has various different meanings.

Personally, I would never use Access for any kind of back end, especially not for a web site. If you want to use something for testing, I would suggest using something like MySQL or SQL Server (there is a free express variation of this available from the Microsoft site).


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dbsquared]

so you are saying this is an access issue the database I have is very small the whole thing is only 400K so we didn't want to have to spend the time for one little db. We are considering converting to Oracle would this fix my issue?
BTW Thank you very much for your responses.


To go where no programmer has gone before.

 

[ca8msm]

The error is a Microsoft Access error, so in that respect, yes it is an issue with Access.

Unfortunately, "Operation must use an updateable query" doesn't really give much insight into the actual problem (reading that error would suggest something like you aren't running an update query). In reality, the error is more likely to suggest that something else is wrong; perhaps security settings for example.

If you do have another database ready to use, I would suggest using it, as Access (in my opinion and experience) produces far too many problems that other databases cope perfectly well with.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dbsquared]

I've done some research and all i've come up with is that access is updateable and this shouldn't be causing any problems as others use access in the same way that I am.

To go where no programmer has gone before.

 

[dbsquared]

found the problem to be a combination ASP.Net and Access here is some more information:

http://support.microsoft.com/defaul...kb;en-us;316675

If any one else runs into this problem.



To go where no programmer has gone before.

 

[dbsquared]

sorry here is a good link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

To go where no programmer has gone before.