Kix Gurus,

I have been following a number of threads i.e. Shawn who has illuminated a number of various issues re: Kix and OLE automation with respect to Access databases. All of the examples posted here are read-only. That part works fine. What I am unable to do is WRITE to a database. This is what works in VB but not KIX:

$x = OLEPutProperty ($cn, "Mode", "I", "3")
$x = OLECallProc ($cn, "OPEN", "s", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\MachineData\Machines.mdb")

$x = OLECallProc ($cn, "Execute", "s", "Insert into tbl_Machines (MachineName) Values ('Test')")

Please Help