I am developing a medium sized inventory/job costing application using DAO 3.5 and Access. Lately I have been getting lots of exceptions like this:
Couldn't update; currently locked by user 'admin' on machine 'Machine'.
The strange thing is, I am being very sure to close all recordsets and there are no other open recordsets from the database the changes are being made to. Or any other databases for that matter(Only a few) This problem persists after I close the program and re-open it. For instance, I'll do something, and it works the first time, then I re-open it and do it again, and it gives me the exception. At first I thought I wasn't closing some recordsets or calling Update. But I am. What could be causing this?

Thanks,
JL