Re: .ldb file stays when connection is closed
From: Derrick (Derrick_no_spam_at_geostrategies.ca)
Date: 02/25/04
- Next message: Scott M.: "Re: .ldb file stays when connection is closed"
- Previous message: Derrick: "Re: .ldb file stays when connection is closed"
- In reply to: Paul Clement: "Re: .ldb file stays when connection is closed"
- Next in thread: Paul Clement: "Re: .ldb file stays when connection is closed"
- Reply: Paul Clement: "Re: .ldb file stays when connection is closed"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 19:25:13 GMT
Yes, when I leave the application, the .ldb file disappears.
Since I posted, I have not been able to duplicate the behavior << In another
form, I connect to the data base, retreive information using a datareader
and close the connection. The .ldb file disappears. >>.
As soon as I connect, the .ldb file appears and stays until the app is
closed regardless of the connection state. I control all the data base
connections through my 'dataConnector' object to make sure there is no
connections left open, so it is easy for me to test for any left over open
connections.
Derrick
"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:ftcp301bobu9iphseffhbvppehsbor7ei9@4ax.com...
> 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)
- Next message: Scott M.: "Re: .ldb file stays when connection is closed"
- Previous message: Derrick: "Re: .ldb file stays when connection is closed"
- In reply to: Paul Clement: "Re: .ldb file stays when connection is closed"
- Next in thread: Paul Clement: "Re: .ldb file stays when connection is closed"
- Reply: Paul Clement: "Re: .ldb file stays when connection is closed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
