How are .ldb files unloaded



Problem: I have an application that reads and writes to my database. I am
trying to do some JRO activities (compact the DB) and also trying to do some
FileCopy actions. I have scoured my code (sure you have, they all say) and
all the connections are closed, but I still see (from my file explorer) that
I still have a .ldb on my database which is preventing the compaction from
running. It is as if even though I have done my "Set adoConnection =
Nothing", that there is still persisting either an open connection OR there
is some problem in removing the lock (or staging of the removal of the lock)
on the database which keeps it extant at the time that I am trying to run my
JRO compaction (which occurs right before my mod main ends.)

Any ideas would be appreciated.

Is there a way to shut down any unknown open connections? (i will use this
in debugging. If using it makes things work then I will need to rescour for
the open connection.




.

Relevant Pages

  • Re: How are .ldb files unloaded
    ... I am trying to do some JRO activities and also ... still persisting either an open connection OR there is some problem ... database which keeps it extant at the time that I am trying to run my ... JRO compaction ...
    (microsoft.public.data.ado)
  • RE: Undeletable Form
    ... An even less welcome discovery was that compaction did not remove ... Eventually I finished up with a database which was nearly ... > It's an object already marked for deletion by Jet. ... > delete class objects from the Project Explorer window. ...
    (microsoft.public.access.forms)
  • Re: Backup Linked BE Tables
    ... be shown to be closed via code, the program execution stack and memory used ... database at the same time. ... and then you should be able to run that compaction code you have. ... I'll have to assume that you have some connection code that opens up the ...
    (microsoft.public.access.modulesdaovba)
  • Interesting issue with compaction. Any ideas to eliminate?
    ... an access frontend database which resides on a DFS target that utilizes ... For those who are unaware of DFS or FRS, ... What I am seeing is that when the compaction occurs, ...
    (comp.databases.ms-access)
  • Re: Undeletable Form
    ... You are correct that the /Decompile switch helps in many cases. ... An even less welcome discovery was that compaction did not ... Eventually I finished up with a database which was nearly ... > shortcut to the command line decompile and named it the 'Carwash'. ...
    (microsoft.public.access.forms)