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.




Reply With Quote