Does anyone have VI's that write to an Access Database that they would like to share?

[Alejandro_zepeda]

First of all, do you have SQL toolkit?

If you dont have it, there is no problem I have some VI to write and read from an acces database.
But is easer if you have sql toolkit.

Pleas let me know if you have sql toolkit

[Greg Vowles]

Thanks a lot for your help! I don't have SQL Toolkit and don't know anything about it. What is it and what are the differences between ActiveX and SQL Toolkit? Where do I get SQL Toolkit? Could you send me both VI's so that I could compare the two different methods or do I need SQL Toolkit to view it? Thanks again for your help!
Greg

[Dennis_Knutson]

Since you don't specify how you want to connect, here are examples with both ActiveX and the SQL Toolkit. I think that the SQL Toolkit is a much better solution.

[Greg Vowles]

Thanks for you help! I really appreciate it! Could you explain to me what SQL Toolkit is and how it works? How is it a better solution? Whats the difference between ActiveX and the SQL Toolkit? I don't have SQL Toolkit. How do I get it?

Thanks, Greg

[Dennis_Knutson]

SQL stands for Structured Query Language and is a fairly standard way of accessing databases. For the most part, a database command written in SQL will work for MS Access, MS SQL Server, Oracle, etc. The SQL Toolkit interfaces to a database via an Open Database Connectivity (ODBC) driver. One advantage of using SQL is its portability. If you ever change databases, its fairly easy to do. If you use ActiveX, moving will require that you have to start from scratch because no two database's ActiveX interface is the same (if they even have one). I've also found that the SQL Toolkit executes much faster than ActiveX. NI sells the SQL Toolkit as part of the Enterprise Connectivity Toolset which also includes SPC and Internet Toolkits for $995. Its also
sold separately for $695.

[Greg Vowles]

Thanks Dennis,
The SQL Toolkit sounds great, unfortunetly the price is way over my head especially after you convert it to Canadian dollars. So I don't think I'll be getting it anytime soon. So in the mean time that leaves me stuck trying to figure out ActiveX for MS Access. Thanks for the example you sent me that really helps!
Greg

[Filipe A.]

Greg;

The best way to do that is by using the SQL toolkit, but I'm attaching an example to write a table to Microsoft Access by using activeX.
Regards
Filipe