I can insert data into an access database, but I need to querry the database for specific information. How do I do it?

[mda711]

I can insert data into an access database, now I need to do some simple querries such as selecting all records that are greater than a certain value or = a certain value. How can I return only the selected records?

[Dennis_Knutson]

You don't mention what you're using to connect to the database. If you're one of the toolkits that uses SQL then you would use the SELECT command with the WHERE clause. Something like:

SELECT * from tablename WHERE columnname > value

You probably want to get a hold of a complete SQL reference if you want to do a lot of queries.

[mda711]

Sorry but I do not have the Connectivity toolkit, everything must be done in labview using Active X

Thanks

[Dennis_Knutson]

If you don't want to spend any money, then instead of ActiveX, I would recomend LabSQL from Jeffrey Travis. I use it instead of the Connectivity toolkit and have had no problems. Besides being free, you have the advantage of being able to use it with any database. ActiveX ties you to Access and you upgrade your version of Access and find the properties and methods are different, you've got a lot of reprogramming to do.

[mda711]

Thanks a million. LabSQL works perfectly. It does exactly what my application requires and with a minimum of hassle. Thanks again