How can I edit data in Microsoft access using ActiveX

[y2jay]

I've tried to modify Read Access DB with ActiveX to edit an entry in my database, but I get the following error

Exception occured in DAO.Field, Update or CancelUpdate without AddNew or Edit..

[Lab Viewer]

As I remember, you have to call "EDIT" method before trying to modify something in DB.

[y2jay]

When do you call the edit method. In VB, I can use the following code to do the required manipulation
With Recordset_
.edit
(manipulation)
.update
end with

Can you help?

[Lab Viewer]

Did you try to do the same thing in LabVIEW (the same order, after you have the right reference to the recordset). I know this kind of problem from VB too. I didn't try it in LV but I supposed it should be the same.
Let me know if it doesn't work.

[y2jay]

I've tried desperately to get it to work, but I've had no luck. I want to edit the last record so I MoveLast, Edit, then I go to Fields, then _Field,and then write the value. I always get Invalid DAO.Argument

[y2jay]

I've tried desperately to get it to work, but I've had no luck. I want to edit the last record so I MoveLast, Edit, then I go to Fields, then _Field,and then write the value. I always get Invalid DAO.Argument

[Lab Viewer]

Can you send me (labviewer@yahoo.com) your VI and database (or something that simulates the problem)? ... my Office is 97.