Access Database ComboBox problem with Labview 2010

[Luca86]

Hi everybody,

I'm writing because I spent some days to fix this problem but I didn't find out any solutions.

I created a database with MS Access 2010 of two tables, one containing information about Companies and one information about Employees (find the database attached).

In the Employees' table I created a column with a multicheck combobox in which it is possible to choose more than one company for each employee.

Till here everything was ok.

Then I wanted to connect the database to Labview 2010 and to read from the tables (find the .vi attached). 

When I tried to read from the Employee' table I cannot get what is inside the column with the combobox, only two types are displayed.

I tried to use the Database Connectivity Toolkit also, but even with that the problem was not solved.

In this case, it is possible to read only up to 11 characters and if the string is longer, the field is blank.

Does anybody have some idea about that?Does some character's limitation exist?

Thanks,

[mikeporter]

The database itself is correct, the people with multiple employers have a semicolon delimited list of company names in that column. I'm not sure why "File 1.vi" doesn't work but in any case you don't need to go through access to get to your data. Remember that Access is not a database. Access is am application development environment utilizing a database engine built into Windows called Jet or ACE. In any case all you need are ADO drivers such as those found here.

Why the database toolkit version didn't work, I have no idea - it is know for behaving strangely and is in any case superfluous...

BTW: The "Access" way of modeling data is very bad form. The proper way of handing one-to-many relationships is with a cross-reference table. It may appear to work right now but sooner or later it will rise up and bite you.

Mike...