RS.MovePrevious??

[scostell]

has anyone else had a problem when navigating a recordset using moveprevios? Here is the strange problem:

I have no problems going forward one record at a time. I can go backwords(using moveprevious) most of the time. But When I'm on the second record It won't move back to the first one. for example:

I start on the first record in the RS and movenext to the 2nd record. When I try to move back to the first one it won't go.

if I'm on Record 3 it will move back to record 2 so I know it's working somewhat.

Excluding that problem everything works fine until I get to about the 45th record of 120. When I try to moveprevious on one of those records it does not go back but forwards for about five records and then does a little dance between record 49 and 50.

understand? is this a bug or is it most likely in my coding?

[Mongo]

If you're using a linked table, local index/sort order or
unindexed/no-primary key table query, you can get this.
Check that you are using an index on the table that is in
your source database. I'll bet your problem lies there.

If your data is in a multi-user environment, you can also
try changing the Cache Size setting of the Command object to 1.
Otherwise, check that you're using > = MDAC 2.1 Service Pack 2
or MDAC 2.5

None of that working, post what kind of cursor you're using
and more detail about your db & versions, so we have more
to go by to help you.