Re: How are .ldb files unloaded

AK wrote:
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.

This is probably a permissions problem. All users of the database file must
have read/write permissions for the _folder_ containing the file. The ldb
file needs to be created under the context of the first user to open the
database, modified under the contexts of subsequent users, and deleted under
the context of the last user to exit the database.

Keep in mind that with OLEDB session pooling, connections are kept open for
60 sec. enabling their re-use.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • How are .ldb files unloaded
    ... I have an application that reads and writes to my database. ... trying to do some JRO activities and also trying to do some ... I still have a .ldb on my database which is preventing the compaction from ... that there is still persisting either an open connection OR there ...
    (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)