How do I programmatically determine if any recordsets are still open?
Posted on 2008-10-26
I continue to get errors like these: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
The record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. . .
So how do I programmatically determine if any recordsets are still open before one function ends and another begins? Is there something else I should be looking for? Help!