Not able to update data in access db
-
It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.
-
It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.
Have you tried looking at the permissions using Windows Explorer rather? Set Write on the file and the folder (keep the dB in it's own folder for this reason) and see if that helps. Access is a PITA with this, totally nonsensical error message too. regards, Paul Watson Bluegrass South Africa Brian Welsch wrote: "blah blah blah, maybe a potato?" while translating my Afrikaans. Crikey! ain't life grand?
-
It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.
Also, in Windows Explorer make sure the correct account has write permissions. In traditional ASP, by default it was the IUSR_...acount. With .NET the deafult is the ASPNET account. Just because I don't care, doesn't mean I don't understand. - Homer J. Simpson