10-25-2008 02:29 PM
Solved! Go to Solution.
10-25-2008 10:09 PM
10-26-2008 10:04 AM
Save yourself a bunch a grief and skip the Access ActiveX interface. Use NI's database toolkit, LabSQL or search the board for other ADO examples. You won't have to open the Access application and you can use any database you want.
10-26-2008 11:36 AM
Thanks for the replies.
I tried the labSQL and Database toolkit. This works fine with the example and other simple databases but not with mine.
The one i got makes use of crossreferences. I think this causes conflicts. (unnamed 1st table - see attachement). Creating a new database is not an option.
That is why i want to use ActiveX but i just cant find the right properties and methods to get the result. It is the first time i try to read from a db.
So, more tips and hints are welcome.
Steven
10-26-2008 12:50 PM
10-26-2008 01:22 PM
Thank Dennis!
This sounds like a good solution! I will try it now.
Steven
10-26-2008 01:46 PM
You were right, Dennis! Thanks! There was just something wrong with my SQL syntax. It was a good idea to use the wizard. Thanks again.
Best regards
Steven
10-27-2008 11:51 AM
One more thing. Is it possible to query a query with labSQL?
Best regards
Steven