open .mdb database

[labview99]

How can I open an .mdb database in Labview?

[Ajay_MV]

Googling or looking at LabVIEW examples (Help>>Find Examples)gives lot of results for this and it works straight away.

Search for mdb in the Find Examples and you can see the Create DatabaseTable.vi which creates the .mdb database.  You can play for opening the existing one too.  This example actually opens the db from C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\database\LabVIEW.mdb

Other google results for your help...

http://www.ni.com/example/26694/en/

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000PADkSAO&l=en-IE

https://forums.ni.com/t5/LabVIEW/How-to-read-and-write-mdb-file-in-labview-without-having-MS/td-p/10...

Thanks,

-Ajay

[labview99]

I have tryed to do following your examples but I can´t choose the option "Microsoft Jet 4.0" I have only these options 

[Ajay_MV]

I guess you need not worry about it.  I also get the error, Microsoft.Jet.OLEDB.4.0 not found.  But still the example works and generates the table in .mdb file as below.

[labview99]

The problem is that I have one access 2000 database and I can´t open the databse in Labview to see all the tables that the database has. 

[labview99]

I found and error when I try to run the VI. I show you my program

[Eric1977]

It's been a while since I tried this with older Access databases but try using the Database Connectivity Toolkit with the connection string from ConnectionStrings.com: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

Make your data source the path to your MDB file. If you have login credentials, put them in the User Id and Password areas.

[labview99]

I just wanted to see all the tables that appear in the database. But first I have to convert and my database which is .mdb to accdb. But I don´t know how to do this. Can you help me please?

[labview99]

I have managed to do it! Now how can I do it so that every time Irun it I don´t have to enter the DB properties? I mean I don´t wan´t to be all the time choosing " Microsft Jet 4.0 OLE DB Provider"

[labview99]

Hola!

Estoy tratando de conectarme a una base de datos, pero cada vez que ejecuto el programa tengo que especificar entre las propiedades DB la opción de " Microsoft Jet 4.0 OLE DB Provider". Lo que quiero es que una vez que selecciona esa opción de DB luego no tenga que estar metiendola constantemente.