ActiveX Acces

[santatra2]

Hello,
does anyone can help me?
I use the Vi in joint, one for my data storage MS access
it already has the Fitre to select the table that you want to read, but I will like to know how added another filter to select another critere in the same table

thank you

[Dennis_Knutson]

Don't use ActiveX for a database. Use.ADO as in theDatabase Connectivity Toolkit or free ones such as LabSQL.

[santatra2]

Thank you for your prompt response.
Can you help me about this ADO?
I am a beginner

[Dennis_Knutson]

https://en.m.wikipedia.org/wiki/ActiveX_Data_Objects

The ADO interface provided from Microsoft is more generic and faster than the ActiveX interface to Access, which isn't even a database. You can use the same, or slightly modified code with all databases. You can purchase the toolkit from NI or do a search for free toolkits. I gave you the name of one.

[santatra2]

in my use, the base is very small given just 3 colone (brand / model / valor)
Have you an example of Vi for Labsql?

[Dennis_Knutson]

LabSQL comes with examples.

[santatra2]

thank you very much
I tried to manage with

[mikeporter]

You can also start here:

http://www.notatamelion.com/2015/01/05/managing-data-the-easy-way/

Mike...

[ByteLABS]

Also for me the best way is to connect to database with ADO by use Report Tooolkit or if you don't have LabSQl or you can create with the same procedure you used to create a DAO based vi's.

IN any case, your code have need (in DAO or in ADO both) to one times only to create connection to the database, use the filter by select case, and after you can close all reference to the database.

I've rebuild your code, you can duplicate the mutsibishi case to create the other choice.