Runtime Error

[rringsred]

Sometimes I get the folowing runtime error message: 'The change was cancelled during notification, no columns are changed'. This runtime error occurs during an updating of a recordset. Thanks in advance.

ryan

[compuGEEK]

Hi,

What are your cursor and lock types? Try setting the following:

CursorType = adOpenKeyset
rstBlah.LockType = adLockOptimistic


------------------
CompuGEEK

[Clunietp]

I have gotten that error when I have tried to manipulate the primary key field when bound to an ADO data control, but I have been able to update the other fields with no problem.

[rringsred]

Thanks Compu,

I will give it a shot and see what happens.

Ryan