when i try to update MSAccess db table TP is showing this error

" current record set doesnt support udpading, this may a limitation of the provider, or of the seleted locktype"

this is the code i used

rs1.Open "select Name from example", adoConnection (example - table name)

rs1.Update "Name", "viki" (Name is the column name)


im able read contents from mdb

i dont know what to do with this.......

help me guys..