>Hi Alhad,
>
>Not sure if this is your problem I remember something about if you don't specifically set your access the recordset will be readonly forward only. I think you might need set adOpenDynamic/adLockOptimistic.
>
>hope this helps
>
>Don

Hi Alhad,

Don is right. You are missing this before opening the RS:

oNewphotoRS.LockType= 4  && adLockBatchOptimistic

Note that the error was thrown in the .AddNew method call -where you had no error checking-. So try debugging the code without the ON ERROR clause, until you have it "up and running", only then put error control in place.

Regards,