Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ado / Adox ?
YAYY!! It's working now. Thanks a lot !!!! K Dales Wrote: I just replied to your previous post, will copy it he 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://msdn.microsoft.com/library/de...dooverview.asp HTH - K Dales "silvest" wrote: anyone has any ideas ? -- silvest ------------------------------------------------------------------------ silvest's Profile http://www.excelforum.com/member.php...o&userid=14662 View this thread http://www.excelforum.com/showthread...hreadid=275742 -- silves ----------------------------------------------------------------------- silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466 View this thread: http://www.excelforum.com/showthread.php?threadid=27574 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ado / Adox ? | Excel Programming | |||
Ado / Adox ? | Excel Programming | |||
Ado / Adox ? | Excel Programming | |||
Ado / Adox ? | Excel Programming |