Why doesn't the ldb go away when the connection is closed?
-
I know this is dealing in ancient technology, but MS Access hasn't yet breathed its last. I copy an mdb template to a temp mdb file, write stuff to the copy using an OleDbConnection, and then close the connection. Next, I want to rename the file, but I can't. The ldb file is still there and I get the error that the file is being accessed by another process. I can copy the file to the new name, but I can't rename or delete the file. Really aggravating is that this doesn't happen when the finished mdb file is under some size threshold. :confused: Then, the ldb goes away immediately when the connection is closed. I've tried connection.Dispose(); connection=null; OleDbConnection.ReleaseObjectPool(); GC.Collect(); None of those release the process lock on the file. It won't release until my application terminates, which is a bit too late. ;) Is there any help for this?