write to MS access

[elyan]

Hi ALL :

I want to send data to  MS access , I have to send these 10 value , i have build a file data base in access ,, that i want these data to be moved to it

and every time i run the applictation with new value these new value send under the old one

 ( row under )

can any one help me with this issue

i have been very desperate, i can build application doing this

thank you very much

[Dennis_Knutson]

Your table has no data in any of the columns except for the autonumber ID column. This implies you are inserting a new record without any data. To understand why this is happening, we would have to know how you writing to the database. Are you using NI's database toolkit and if so, what functions are you using? Posting your code would be more benefical than an image of the table.

[elyan]

Hi :

I build an application so I can read the data from Access .. i insert the data value manually , becasue i can't yet send through labview  

please see attach file i send you the vi and the access file as zip

thanks

[Dennis_Knutson]

Why are you using ActiveX? Did you find this code somewhere? I don't have Access installed (and never want to install it) so I can't run your code. I would highly recomend at either buying the database toolkit or using LabSQL from http://jeffreytravis.com/lost/labsql.html. You can also search the forum for ADO to find some other examples. You'll need to invest a little time into learning SQL but it will be worth it. You won't be tied into a specific database, you won't have to install Access, and your queries will run much, much faster.

[elyan]

Hi

I download the toolkit LABSQL ... i look at the example,,

please see attach file ...why i can't recall the data always give this error " Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified in ADO Connection Open.vi->Example - Fetch a Table.vi"

sorry but this issue is new for me , so its difficult to me

thanks

[Dennis_Knutson]

To make it seimple to start, go to windows Settings>Control Panel>Administrative Tools and start the Data Sources(ODBC) program. This is a program that allows you to configure an ODBC data source. You assign a name and select the database for it. This missing name/source is what the error is refering to.

[mikeporter]

You are approaching your problem in a fundamentally incorrect way. The basis of your error seems to be that you think Access is a database - it's not. Access is an application development environment that commmunicates with an underlying database (by default) called Jet. The Jet database engine is built into Windows so you don't need Access to interact with your mdb file.

Next, you need to be making connection using an ActiveX interface called ADO (ActiveX Data Objects). Do a search for database stuff associated with my name and you'll find several good discussions of the topic as well as sample code from a bunch of folks.

Mike...