Re: .ldb file stays when connection is closed

From: Scott M. (s-mar_at_BADSPAMsnet.net)
Date: 02/25/04 

Date: Tue, 24 Feb 2004 23:23:11 -0500

My guess is that ADO.NET uses connection pooling, so even when you close
your connection, it is still in the pool?

"Derrick" <Derrick_no_spam@geostrategies.ca> wrote in message
news:MVT_b.610246$X%5.68987@pd7tw2no...
> I am working on a vb.net app that access an MS Access Data base.
>
> I am having a confusing problem, and was hoping to get a little
> clarification.
>
> One form creates the .mdb file and creates the tables and constraintes
using
> DDL and a command object using its executeNonQuery() method. When I close
> the connection, the .ldb file stays. I checked the connection state and
it
> reports closed.
>
> In another form, I connect to the data base, retreive information using a
> datareader and close the connection. The .ldb file disappears.
>
> Both forms create an instance of same class and call the same methods to
> connect and disconnect.
>
> So my questions are:
> 1. should the .ldb file disappear when the connection is closed?
>
> 2. If it should, what could cause it to remain when the connection is
> closed?
>
> Thanks for your help
>
> Derrick
>
>

Relevant Pages

  • .ldb file stays when connection is closed
    ... I am working on a vb.net app that access an MS Access Data base. ... I checked the connection state and it ... The .ldb file disappears. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Support for multiple database
    ... I kept the "Data Connection Name" same in both cases, ... Can I store the value of the Connection String in a variable and use ... Now I have built a similar to SQL Data Base in MS Access. ... I attached the MS Access Data Base in the "Server Explorer" ...
    (microsoft.public.dotnet.languages.vb)
  • Re: .ldb file stays when connection is closed
    ... Yes, when I leave the application, the .ldb file disappears. ... closed regardless of the connection state. ... I control all the data base ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to Access DataBase
    ... With Access if the database is open there is an ldb file of the same name as ... The first connection creates this ldb file. ... If there is no ldb then there is no connection. ... > Dennis in Houston ...
    (microsoft.public.dotnet.languages.vb)
  • Pending delete on LDB file from ADODB connection to Access 2.x database
    ... Users can connect and disconnect the Access app ok at this point ... Database access is via network file shares with full access rights ... Database connection control is 2 ... Once in this state, all new attempts to open the LDB file will fail, ...
    (microsoft.public.vb.database)