Add data to an Access database using ActiveX?

[y2jay]

I use Bridgeview to control software (through DDE) that then controls a potentiostat. The software generates a database file that I want to immediately append. I don't have the SQL toolkit so I was hoping that ActiveX would work

[John Lum]

There have been numerous threads on this exact topic in the LabVIEW newsgroup and the NI Developer Exchange site. Here's a particularly good one from about a month ago with lots of input from experienced users:

http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RNAME=ViewQuestion&HOID=506500000008000000041E0000&ECategory=LabVIEW.LabVIEW+General

Note recurring advice to consider the NI toolkit, especially if time is anywhere near as important as money in your situation.

Regards,
John Lum
National Instruments

[greenman]

>
> Note recurring advice to consider the NI toolkit, especially if time
> is anywhere near as important as money in your situation.
>
> Regards,
> John Lum
> National Instruments


It has been my experience that with practice, programming with ActiveX
is every bit as fast as using the SQL toolkit.

[jason clark]

greenman wrote in message
news:1a51ebaa.0106250459.6ff0d6b8@posting.google.com...
> >
> > Note recurring advice to consider the NI toolkit, especially if time
> > is anywhere near as important as money in your situation.
> >
> > Regards,
> > John Lum
> > National Instruments
>
>
> It has been my experience that with practice, programming with ActiveX
> is every bit as fast as using the SQL toolkit.

I have written a simple control that allows Labview to send SQL queries to a
database, very simple, and it paid for VB6.
Of course, my simple control does not compare to the SQL Toolkit, but it was
only 2 hours work, and the project only needed to send time-stamped data on
a button pressed event.
The price difference between th
e SQL ToolKit and VB was £200-300 so it was
well worth the effort. For more complicated database work, the Toolkit
should prove a more worthwhile investment.

My newserver doesn't have the original post of this thread, but I'm willing
to supply the ActiveX control & Example Vi, if they email me.

Regards,
Jason
jason34@btinternet.com

[y2jay]

John:
Thanks. This was very helpful and I have been able to read and write into my database. However, I have developed another problem in that Microsoft Access does not properly close. Do you have any other suggestions?