Writing records MS Access records from LabVIEW

[Patekkio]

I'm trying to write new records to a MS Access table from within LV. I need to use ActiveX (no chance for SQL toolkit). I'm able to create new records in the database table, but cannot write values in the fields. Can anybody help me?

thanks in advance

Giovanni Moschioni

[Dennis_Knutson]

You could use ADO instead. See http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=50650000000800000066280000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0 for more information.

[Lab Viewer]

Hi Giovanni,
as far as I remember, before trying to do any changes to an existing field, you should call the Edit method.

[Patekkio]

Thanks for answer; as a matter of fact my problem is how to tell Access 'hey, I want this field of this record to be this value'. In a nutshell I'm not able to translate into LV the following statements extracted from MS Dao Help file:
"
.AddNew
!Name = strName
!Surname= strSurname
.Update
"
Thanks again for help!

Giovanni Moschioni

[JellyBeans]

You also might wana try
LabVIEW 6\examples\comm\access.llb

A Rafiq