Re: How are .ldb files unloaded


Bob,

Thanks!
Here is my connection string.


strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Password=MyPassword;User ID=MyUserId;" & _
"Data Source=" & My_DatabasePath & ";" & _
"Jet OLEDB:Engine Type=5;" & _
"Jet OLEDB:Database Password=MyDataBasePassword;" & _
"Persist Security Info=True;" & _
"Jet OLEDB:System database=" & My_DatabasePath_MDW_SecurityFilePath &
";" & _
"Jet OLEDB:Encrypt Database=True"

Are your saying that I need a Mode=ReadWrite somewhere in here?
Like at the last lines (as in):

"Jet OLEDB:System database=" & My_DatabasePath_MDW_SecurityFilePath &
";" & _
"Jet OLEDB:Encrypt Database=True;" & _
"Mode=ReadWrite"

Did I put it in correctly?
Kinda real new to all this!

Thanks
AK

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:uDe9YtKCHHA.1300@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)