readonly error

C

Charlie

I'm using this:
Do While Not rs1.EOF
to loop through a table and find a string. When I find the string, I want
to delete it, but the rs1.edit give me a readonly error.
Is it possible to make changes to rs1 while looping through it like this?
Thanks,
ck
 
P

pietlinden

I'm using this:
Do While Not rs1.EOF
to loop through a table and find a string. When I find the string, I want
to delete it, but the rs1.edit give me a readonly error.
Is it possible to make changes to rs1 while looping through it like this?
Thanks,
ck
Click to expand...

not on a forward only recordset, no. They are read-only. Post your
code. If you open a recordset with dbOpenTable, then you can update
the records.
 
Top