Ado / Adox ?

[silvest]

Hi, i'm not too familiar with VBA in Excel, but i'll try my best.

I'm trying to run a macro that'll generate numbers and fit it into
Access DB (which i've created using another macro)

the loop seems to be running fine, but an error occurs saying: "Either
BOF or EOF is TRUE, or the current record has been deleted. Requested
operation requires a current record."
and points towards this line: "

--> Recordset1.Update <--
Recordset1.Close
Set Recordset1 = Nothing

 

[Myrna Larson]

Can you post the rest of your code, specifically the line(s) that open the
recordset?

 

[Guest]

Either you do not have a new record created when you are trying the 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 to update
you run into the EOF. This would give the error message you are seeing.

If this is the case, make sure your code does the following after 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 new record
Recordset1.Update
....

A couple other things:
- Be sure to Update before any MoveNext, otherwise you will move past the
end of the file.
- Make sure your recordset's LockType allows updating and is not allowing
Access to lock the record or table on you, preventing any updates. I suggest
using adLockPessimistic to ensure you have full possession of that record
until you actually update it.

For all you ever wanted to know about ADO
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/dasdkadooverview.asp

HTH - K Dales