How 2 solve this err - "Operation must use an updateable query"

[byan]

My database access is using this code : dim dbconn,sql,dbcomm,dbread dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; &_ data source=" & server.mappath("er.mdb")) dbconn.Open() sql="update bldinein set showno = '' Where billing_no = ''" dbcomm=New OleDbCommand(sql,dbconn) dbread=dbcomm.ExecuteReader() dbconn.close() But when I upload the file 2 internet, there will show error msg "Operation must use an updateable query". How 2solve this problem? :^)

[Mike Ellison]

Does your table [bldinein] have a primary key?

[byan]

Ya, my [bldinein] table got primary key, [billing_no] is the primary key!!!:doh:

[Mike Ellison]

Does your ASP.NET process account have access to write to the .mdb file and to its containing folder?