Im not able to run my program witht the following code!

Dim rst As ADODB.Recordset
Dim sql1 As String
   sql1 = "insert into Passport_Release VALUES('0259','14/09/2008','returned')"
CN.Execute sql1 As Recordset

instead of the last statement i even tried CN.Execute sql1 alone....
but nothing is working... i doubt if error is in my reference... please help as its very urgent!

Is this thread was solved??
if yes then please post the answer. It will help other member who get the same problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.