labview & ms access

[nicB]

Hi,

I've connect my access database with labview by uising the activeX connection (DAOEngine)

This work correctly,but now i need create a sql select...innerjoin query between two table of my DB.

I see the problem is the count byte property of recordset, get one record (reality is more records).

The attached ExtractTable is in LV6.1 :headbang:

Thanks for HelpMe

Bytelab

Download File:post-395-1094465031.llb

[snooper]

Hi,

I've connect my access database with labview by uising the activeX connection (DAOEngine)

This work correctly,but now i need create a sql select...innerjoin query between two table of my DB.

I see the problem is the count byte property of recordset, get one record (reality is more records).

The attached ExtractTable is in LV6.1 :headbang:

Thanks for HelpMe

Bytelab

1654[/snapback]

To get the record count or any count using ADO in combination with a recordset you need to have exclusive access rights to the recordset. Try opening your recordset using "lock optimistic" functionality.

Also have a look at a new database toolkit at www.tm-solutions.nl\eng\

Greetz