add records in table ACCESS from labview by ActiveX

[kiki]

I try to add records in table of database ACCESS by an ActiveX from labview but my programme doesn't work ...

What is the problem ?
I have attached my VI

Thanks in advance
hasna

[JRA]

What trouble are you having with the VI? I ran it but nothing happened.

[kiki]

No problem with this VI but I have another problem with another VI, I attached it...

thanks to see it and tell me what is the problem

[JRA]

I have run your VI. I received an error -2147221164. It does not give further information because that error code comes from your ActiveX Server. I obtained this error code by wiring the error nodes together between your VIs. I saved this and am reattaching it so that you can find which error is occuring on your computer. Let me know what you find.

[kiki]

the problem is a problem of connection of the value of a field and a string. This is a problem of type...

Thanks for all

[Lab Viewer]

I saw your previous posts related to ActiveX/Access. I once had the same kind of problems. It's not an easy task (without a toolkit) because you have to learn the "interface" provided by Access/DAO in order to manage what you are trying to do.
In my case, the best solution it was to follow the Visual Basic for Applications examples included in MS Access. Even though you don't know VB, don't be afraid. Important is to figure out from that example what methods/properties you need to use, the proper order to call them and eventually some parameters. You are dealing with the same methods/properties in LabVIEW, the difference is that you have them in a graphical format instead of text .You can find these examples by going to MS Access help > Index and type DAO obj
ects and then choose one to start with (Database, recordset, field �).

Hope this helps

[L]

On Thu, 11 Jul 2002 08:13:48 -0700 (PDT), Lab Viewer
wrote:

>I saw your previous posts related to ActiveX/Access. I once had the
>same kind of problems. It's not an easy task (without a toolkit)
>because you have to learn the "interface" provided by Access/DAO in
>order to manage what you are trying to do.
>In my case, the best solution it was to follow the Visual Basic for
>Applications examples included in MS Access. Even though you don't
>know VB, don't be afraid. Important is to figure out from that example
>what methods/properties you need to use, the proper order to call them
>and eventually some parameters. You are dealing with the same
>methods/properties in LabVIEW, the difference is that you have them in
>a graphical format instead of text
.You can find these examples by
>going to MS Access help > Index and type DAO objects and then choose
>one to start with (Database, recordset, field =85).
>
>Hope this helps

The examples on NI's website were originally written using the DAO
model, but the latest one was written using the ADO model.

However, I am unable to find either example LLBs on their website
anymore. Maybe they're trying to push their SQL Toolkit.

Along with the VBA help in MS Access, I *highly* recommend the book
ADO Programming for Dummies. Wonderful book. Helped me understand the
VBA help. 🙂

Again, if anyone is intersted in VIs using ActiveX that works. He/she
is welcome to email me.

Linda

[Labviewguru]

Egads, Active X for interfacing with Access?

Try getting the SQL toolkit. You'll be glad you spent whatever petty amount of money it costs. SQL is more reliable, easier, and is universal. You can change databases very easily.

[Underflow]

Just some information: The current version is called the Database Connectivity Toolset. It uses ActiveX at its core to connect to databases through ODBC or ADO in Windows systems. It does, however, have some limitations. For instance, large data sets can cause some issues.

Other resources, some database, some more general:
http://www.jeffreytravis.com/lost/

http://www.openg.org/home.cgi

LabVIEW at so
urceforge.net

and finally
the labview webring

These can require a lot of searching, but there's good stuff out there. Good luck!