.ldb file stays when connection is closed

From: Derrick (Derrick_no_spam_at_geostrategies.ca)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 02:39:40 GMT

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

  • Re: .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: please help
    ... > aplication for a PDA(whit a data base) and i don't known do "select * from ... support ADOCE, and the .NET languages use ADOCE.NET, which is another beast. ... An .mdb file is an Access database. ... Open the connection to the database. ...
    (microsoft.public.windowsce.embedded.vb)