[panjavishnu]

hi i am using swf kit 2.2. ur code is working to access data from ms access. but when i tried to update the database an error message is comng

I used this code:
var conn = new ActiveXObject("ADODB.Connection");
connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = D:\\student.mdb";
conn.open(connstr);

var record = conn.Execute("update stud set age = 30 where Id = 1");
fld = record.fields["age"];

trace(fld.value.toString());


conn.close();

And the errors are:

ADODB.Fields.Item cannot be found in the collection corresponding to the requested name or ordinal. See also C:\WINDOWS\HELP\ADO270.CHM.
Warning: using undefined varialbe "fld"
Warning: using undefined property "Value"
Warning; unknown method "toString"
undefined

Please help me this is in my project