I have a problem going backwards in a recordset I can go forward w/o a problem but if I try going to the previous record I get the following error:

Operation is not allowed in this context.

here is my connection routine I made comments b/c these things were throwing errors.

SQLlookup = "SELECT * FROM prepress"

Set connList = server.createobject("ADODB.Connection")
connList.ConnectionString = aConnectionString
'connList.CursorLocation = adUseClient
connList.open

Set results = server.createobject("ADODB.Recordset")
results.ActiveConnection = connList
results.CursorType = adOpenKeyset
'results.LockType = adLockOptimistic
results.Source = SQLlookup
results.Open

I've tried using different locktypes and cursor types but nothing seems to work. All help is appreciated. Thanks

I needed to include this <!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" --> and then everything worked thanks all.

This is the typelib for ado 2.5 - did you just have to update your mdac or was this just left out of your page ?

hi,
i tried to add the metadata line in the beggining of my asp file, like this:

<%@ LANGUAGE = VBScript %>
<% Option Explicit %>
<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

i still cant use moveprevious and get that damn error "cant use in this context.."

what did i do wrong?

thanks, noam