John,
If you are not using the SQL Toolkit, you will need to communicate with the Jet database through its ActiveX interface...also known as the DAO.Engine. You should be able to access the DAO objects on your computer through the ActiveX Object and Automation Refnum objects in LabVIEW.
As for your second question, I believe I found the example you refer to above, and I think it is not working because the example uses a DSN name that is probably not configured on your computer...make sure you specify a properly configured, appropriate DSN whenever you run the example.
If you are going to be using LabVIEW to communicate with databases in a lot of your programs, I recommend you use the new Database Connectivity Toolset for LabVIEW. This new toolset is superior to the
old SQL Toolkit in ease-of-use and functionality, and it includes many fixes for bugs that were in the old SQL Toolkit. You can learn more about it at http://www.ni.com/labview/db_connect_toolset.htm .
Good luck with your application, and have a pleasant day.
Sincerely,
Darren Nattinger
Applications Engineer
National Instruments
