MoveLast &MoveFirst stopped working.. Problem redefined a bit!

[Jim Brown]

I've been working on some code for a while and the line

Adodc2.Recordset.MoveLast
 
'or
 
Adodc2.Recordset.Movefirst

always worked.

Now they mysteriously fail with the error -2147217842, "Operation was cancelled' which is about as much use as an error description as tits on a bull.

It's an Access database, so I opened it in Access and it looks fine; it opens correctly and there's no corruption that I can see.

Anybody got any thoughts here, please?

edit.... btw I tried some suggestions I saw in here after doing a search; .update .requery but to no avail. Funny thing is it was working and now it's busted.

[mendhak]

WEll... try posting your code?

[Jim Brown]

It's just an AddNew to clear the databound boxes, and a MoveLast to move away from the newly added record in a confirm button.

BUT.... as I said it was working. So I used a different proggy to access the db and I got the same fault. When I point the adodc at an older version of the db it works again.... so I think that in spite of the db looking OK in Access, it must be buggered somehow.

So what can be wrong with the database?