Updating of access using vb

[dreamer_lek91]

The question I am going to ask involves Mircrosoft Access and VB and I am stuck with it.

This is the question:

I have 4 peoeple: L, M, N, O, P
there are 4 object: a, b, c, d, e

L has: a, c, d
M has: a, d, e
N has: b, d, e
O has: b, c. d

If I change the a to another name call 'z', I want onli L and M to change as well.

Is there any code which I can use?

[AndreRet]

Yes there is. It will be something along these lines -

MyRS.Open "SELECT * FROM MyTable WHERE MyObject LIKE 'a%'", MyConnection, adOpenstatic, adLockoptimistic