Access

[sandeep v]

Which is the easiest way to access MS Access from LabVIEW 7.1 without using database connectivity toolkit?

[pawel]

Hi

What do you mean access MS Access? Is it the application or database you are refering to. If it is application, you can not do it, and even DB toolkit will not help. If you want to read and write to database, the best way is to use DB toolkit. If you do not want to buy it, you can use some open DB SQL toolkits. I saw one, it is called LabSQL.

good luck
Pawel

[Jeremy_L]

You can do this, but it will be pretty difficult. The Database Connectivity Toolkit leverages ActiveX Data Objects, and you could do something similar. Access is an automation server and so you can get activex objects and use property nodes and invoke nodes to access your database through Access's interface. Now, if you want to avoid the Access interface and just go straight to your database, then you'd have to be using the ADODB ActiveX object. I would say for your benefit that the Database Connectivity Toolset will save you many headaches and problems because these VIs are already set for you to do the important work (i.e, your project work) instead of spending all the time setting up and configuring your connections and objects.

[pawel]

Hi Jeremy

I though (I read it somewhere) that Access is only one from the Office family that does not support automation, that's why I answered the previous post of Sandeep in that way.
But after your post I checked the automation server list and I found "Access._Application" under the "Microsoft Access 9.0 Object Library Version 9.0", so it looks like this is the one.

Sandepp:, I am sorry for this mistake.

cheers
Pawel

[wolf4124]

Hello

can you help me.
I use LapWindows CVI and i will not order the SQL Toolkit for two fields/values.
Do you know a Tollkit for LapWindows or can you say me a Tollkit that works wifh activex.

Thanks

[pawel]

Hi

Sorry, I do not know much about LapWindows.

cheers

Pawel