write data on database ACCESS from labview

[kiki]

Hi!

I want to write on a table of database from labview... I have already succeeded in opening the base and the table but I don't know how write on it... I know that I must use

with Table
.Addnew

Table.Fields(0)=what I want to write

.update
end with

But how do it with labview ???

Thanks in advance
hasna

[Super Fly]

A couple of comments/answers:

1. Here is a link to an example that may help.

http://zone.ni.com/devzone/explprog.nsf/6c163603265406328625682a006ed37d/3ba2809b51dc85f4862565fe000882b5?OpenDocument

2. National Instruments make a Database Connectivity Toolset that makes this process VERY easy. I've tried the way you are doing it and spent a lot of hours figuring out the code. The toolset makes it much faster.

http://sine.ni.com/apps/we/nioc.vp?cid=6429〈=US

[kiki]

yes, I know that with the Database Connectivity Toolset It is very easy but I can't use it because I haven't got it. I use ActiveX to do my VI...
I want to add that I've succeeded to add records on database but I can't write nothing in them...

Is it a solution to My problem ???

thanks in advance
hasna

[Super Fly]

Try making use of your error cluster to gain more insight into the issue. It is difficult to debug without the database.

[kiki]

could you see my programme and tell me what I must add between addnew and update to add records in my database...

[JRA]

Hi Kiki,
I believe you have another Developer Exchange Forum open for this issue. To keep them similar, I am attaching an updated version of your VI. It is wired to read any errors which occur in the VI. I received error -2147221164. This does not help too much, because the meaning of this error depends upon the ActiveX server. You will want to run this VI yourself, see which error you get, and then consult the ActiveX Server documentation to find the meaning of the error.