What could cause being unable to close a Recordset?
Posted on 2001-09-16
My application is MDI. I have a child form which opens a recordset on a table, keeps it open as long as the form is up, and then when the form is about to be unloaded, attempts to close the recordset.
For some reason, in some circumstances I repeatedly get Error #3219, "Operation is not allowed in this context."
I have two other recordsets which are also opened initially and closed at unload time, and they give me no trouble.
I've tried a bunch of things, and have wasted over a day banging my head against this stone wall. It would sure help if someone could suggest one or more things which might cause this problem.
Has anyone come across this particular problem before? If so, I'd appreciate your input.