Problem regarding ADO

[arianchap]

I am working on a project . In that project I am using the ADO 2.0 library from the references . I am not using the ADO control . The problem is that move next and move first properties work properly but the other two i.e move previous and move last show an error like :- this operation is not possible in this context OR the rowset cannot be moved backwards . I have written whole of the code from a book and used the jet3.51 provider for Ms Access . If anybody can help me then indly send me the solution as soon as possible as my project is pending everyday . Thanks in advance .

Hi, are u sure you gave the cursortype as keyset or dynamic. I think by default if u dont specify the cursortype then it takes forwardonly or so. Check this out. This might just be the problem. All the best...vijay