K Dales Wrote:
> I just replied to your previous post, will copy it here:
>
> Either you do not have a new record created when you are trying th
> update,
> or else Access is locking it from you, preventing the update.
>
> Did you remember to call the AddNew method of the recordset? If not
> you
> have not yet created the space for the new record, so when you try t
> update
> you run into the EOF. This would give the error message you ar
> seeing.
>
> If this is the case, make sure your code does the following afte
> opening
> the recordset:
> Recordset1.AddNew 'optional: add field list and value list here, or:
> ' you will need code here to initialize all the fields in the ne
> record
> Recordset1.Update
> ....
>
> A couple other things:
> - Be sure to Update before any MoveNext, otherwise you will move pas
> the
> end of the file.
> - Make sure your recordset's LockType allows updating and is no
> allowing
> Access to lock the record or table on you, preventing any updates.
> suggest
> using adLockPessimistic to ensure you have full possession of tha
> record
> until you actually update it.
>
> For all you ever wanted to know about ADO,
> http://www.hide-link.com/
>
> HTH - K Dales
>
>
>
