I can't do recordset addnew and recordset.update..why?

[apaza]

I wrote an asp application on my pws server with a connection to an access database.
I can succesfuly read the recordset but i can't addnew or update.
i also checked if hte methods(addnew and update) work on my recordset: recordset.supports(adaddnew) and i got true.
everytime i run this page i get:
ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

/prjectI/Lord.asp, line 28

line 28 is -addme.addnew(when addme is my recordset)
please help
apaza

 

[culshaja]

If you just used the default cursor type and cursor location you will get a forward onlty cursor which does not support additions to the database.
This assumes taht you are using ADO.

Try the following:

set rsMyRecordset = Server.CreateObject("ADODB.Recordset")
set rsMyRecordset.ActiveConnection = cnMyConnection
rsMyRecordset.CursorType = adOpenDynamic
rsMyrecordset.Source = strSQL
rsMyRecordset.Open

The use of

myRecordset.CursorType = adOpenDynamic

allows updates and additions. The use of

adOpenKeyset

also allows additions and updates, but does not allow you to see other users additions.
James [sig]<p>James Culshaw<br><a href=mailto:jamesculshaw@active-data-solutions.co.uk>jamesculshaw@active-data-solutions.co.uk</a><br><a href=

http://www.active-data-solutions.co.uk>

Active Data Solutions</a><br> [/sig]