i need help in ADO connection during insertion

[kasideepak]

my statement is:
<%set cs=server.CreateObject("adodb.connection")
cs.Open "provider=microsoft.jet.oledb.4.0;data source=d:\asp\lo.mdb"
regno=1130
cs.Execute "insert into attendance (registerno) values ("&regno&")"
%>
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/asp/new.asp, line 5


i want to know about what is this error?

[serdarbyktmz]

your script look correct for me but maybe you don't have the permission to insert value to that table

but did you set the openconnection and try it with ()

maybe works
i just read your question and want to answer

<%



set cs=server.CreateObject("adodb.connection")
cs.Open "provider=microsoft.jet.oledb.4.0;data source=d:\asp\lo.mdb"
regno=1130
cs.Execute ("insert into attendance (registerno) values ("&regno&")")
%>

my statement is:
<%set cs=server.CreateObject("adodb.connection")
cs.Open "provider=microsoft.jet.oledb.4.0;data source=d:\asp\lo.mdb"
regno=1130
cs.Execute "insert into attendance (registerno) values ("&regno&")"
%>
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/asp/new.asp, line 5


i want to know about what is this error?

[vijaydiwakar]

my statement is:
<%set cs=server.CreateObject("adodb.connection")
cs.Open "provider=microsoft.jet.oledb.4.0;data source=d:\asp\lo.mdb"
regno=1130
cs.Execute "insert into attendance (registerno) values ("&regno&")"
%>
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/asp/new.asp, line 5


i want to know about what is this error?

just try this qry
cs.Execute "insert into attendance (registerno) values ("& regno &")"