Re: .ldb file stays when connection is closed

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 08:44:26 -0600

On Wed, 25 Feb 2004 02:39:40 GMT, "Derrick" <Derrick_no_spam@geostrategies.ca> wrote:

¤ 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?

Yes.

¤
¤ 2. If it should, what could cause it to remain when the connection is
¤ closed?

Perhaps you have an implicit connection from one of your other data objects. What happens when you
terminate the application? Is the .LDB file removed?

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

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: .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: 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
    ... My guess is that ADO.NET uses connection pooling, ... > I am working on a vb.net app that access an MS Access Data base. ... The .ldb file disappears. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Front End Back End Problems
    ... And noone is actually opening the database exclusively. ... can also sort of "watch" the .ldb file and observe its behavior and make ... > stored in a second back end data base. ... It seem to straighten out for all computers ...
    (microsoft.public.access.security)