[thelist] asp ... I'm beginneing to believe one can't reallyupdate a record using it! :(

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Joshua Olson" <joshua at waetech.com>
Subject: Re: [thelist] asp ... I'm beginneing to believe one can't
reallyupdate a record using it! :(


: > The message I get is:
: > Microsoft JET Database Engine (0x80004005)
: > Operation must use an updateable query.
:
: Laura,
:
: One more thing.  This error is thrown when you haven't specified the
correct
: cursor type.  Make sure you select a cursor type that allows for recordset
: updates.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Actually, you'd see something like:

ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.
/test/updatetest.asp, line 17


Cheers
Ken