save data and update in ACCESS

[wisam elyan]

Hi all : Attach see this vi … I create I table in access for limit configuration ,,, I succeed to read the data ,, but I want to change some specific value when from labview and saved it again in the same file in access in the same table  How can I do that in Labview update or saving data  

Please when you run the vi choose the correct path to recall the data  

Thanks

 

[Broken_Arrow]

Your VI shows that you have command of the property nodes. Looks like all you need is the AddNew property of Recordset. See attached.

[wisam elyan]

Hi :

first of all thank you for your fast response

can you help me with the vi ,, I am new in this section .. What I want to do to change for example Min value ( volt) from 1 to 3 and save it in same table

and every other value can be update in the same way

thanks very much again

[Broken_Arrow]

If you just want to change values, you can use direct SQL commands. See the attached screenshot. Note the mentioned website for commands. With a few simple property nodes, you can do what you need.

Your mdb file does not open for me, so I can't make this for your specific table, but you should get the idea.

[wisam elyan]

Hi  First of all I appreciate your help : But may be I not explain my need very well … I want to update the value from the table it self ,, what I mean I explain in step 1-       after I load the data from access file , these data loaded in table 2-       this table is as indicator so I can't change value

3-       I want to control on this table ac control . and if I want to change specific value for example row 0 , column 1 ,, I change it from table and then this new value update in access file

   I hope I explain this problem well now  

Again thanks a lot  

 

[wisam elyan]

Hi :

I try to do what you send for me but always i get error

attach see file please ,,

[wisam elyan]

Hi again

please tell me what i am doing wrong ?

attach see file please

thanks

[Broken_Arrow]

Take out the %s after Data Source=

[wisam elyan]

Hi : This is related to same issue  I have little question … I set password to my access file for update protection  … attach see file please … I do another thing to load user name into list …  

My problem is :

 When I set password I the list sign is disable  but when I cancel the password I can choose user name through the list   

My password for access file is : 1

what's i am doing wrong

thanks you very much