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

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

VB Code:

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.

WEll... try posting your code?

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?