But actually now I am confused. I have read the ADO API, and it states that the Open method 5 optional parameters, but Kix say they are required ??? But OK kix2001 is still in beta, but anyway. When I try the below code, I dont get any returncodes, does it work, or dont it work???

code:

---

; Create and open ADO connection
$objConn = Createobject(ADODB.Connection)
$RC = $objConn.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=c:\db1.mdb", "", "", "")
; Create Recordset object
$objRS = Createobject(ADODB.Recordset)
$strSQL = "SELECT * FROM TABLE1"
; Open Recordset (Query the database)
$RC = $objRS.Open ($strSQL, $objConn, "", "", "")
; Move to the first entry
$RC = $objRS.Movefirst
$RC = $objRS.BOF
Messagebox("'$RC'", "Test", 64, 0)
; Clean up
$objRS.Close
$objConn.Close

---

I have tried to make errors on purpose, but I still dont get any error codes Shawn please use the force

------------------
Cheers....

David