Operation must use an updateable query

[rbutch]

guys, this is pretty strange to me. im using access db as a back end.
as long as im in localhost/WebForm1.aspx im fine.
but if i put this on another pc, i get a "Operation must use an updateable query"
message when doing an insert. anything else works just fine.

if anyone has any ideas why this would work perfectly while running on the localhost, but not when its dropped into a virtual directory on another machine, please let me know.

Dim newDataRow As System.Data.DataRow
newDataRow = DsCustomer1.Customer.NewRow
newDataRow.Item("fname") = txtFirst.Text
newDataRow.Item("lname") = txtLast.Text
newDataRow.Item("address") = txtStreet.Text
newDataRow.Item("city") = txtCity.Text
newDataRow.Item("zip") = txtZip.Text
newDataRow.Item("social") = txtSocial.Text
DsCustomer1.Customer.Rows.Add(newDataRow)
daCustomer.Update(DsCustomer1)

thanks rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

 

[rbutch]

Never Mind i figured it out. it's all about the permissions
thanks
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

 

[Juan T. Llibre]

Usually, when you get the error
"Operation must use an updateable query"
when working with Access databases, it means
that the ASPNET ( IIS 5 ) or NETWORK SERVICE (IIS6)
account(s) don't have write permission to the directory
where the Access database resides.

Give the appropiate account write permission
to that directory, and your problem will go away.

The problem is that, for security, a .lck file has to be
written to the directory where the database resides in.



Juan T. Llibre
ASP.NET MVP
===========