How can I add a new record in an Access table.

[JimiH]

How can I add a new record in access with LabView, using activex, without using the database connectivity tools.

Message Edited by Noawena on 05-16-2008 09:25 AM

[falkpl]

Much easier with a toolkit but you could use ADO objects,

get connection, make a SQL object "INSERT record INTO table where  ...." 

Execute the parameterized query

Free up record sets data

close connection when done.

This is a very simplified version

Paul

[smercurio_fc]

If you're looking for an alternative to the NI toolkit there's LabSQL or the ADO Toolkit.

[JimiH]

Thanx, this is verry helpfull. I'm not there yet but it is prommissing.