access ldb

[S. Justin Gengo]

Graham,

The ldb file will eventually time out. It takes a while though. I'll see if
I can find any way to set it's timeout period to be shorter, but my guess is
that it may be tied to the session object which would have a timeout period
of 20 minutes by default unless set otherwise. I'll experiment a little and
see if this is the case.

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
[url]www.aboutfortunate.com[/url]

"Out of chaos comes order."
Nietzche
"Sabre" <maximNOSPAM@wave.co.nz> wrote in message
news:uXKULC9UDHA.1680@tk2msftngp13.phx.gbl...

> Hello All
>
> For some reason my Access XP record locking file is not clearing. Even if

I

> use Explorer and manually open the mdb and then close it, ldb is still
> there. Is there any way to delete the file using Explorer or other means?
> Any thoughts on why ldb sticking? (I'm opening database in code, with
> password).
>
> Thanks!
> Graeme
>
>

[Sabre]

Thanks Justin. I've just had another look and the ldb is still there (5
hours later). But this time I managed to delete it using Explorer. So maybe
your timeout has somthing to do with it (my session is set 30 min at
present). Or maybe because I reboot the computer? Funny thing though is I
have similar problem with plain old Access sometimes (different computer at
work) and it needs a reboot to fix. It would be good to find a shortcut
though : )

Graeme
"S. Justin Gengo" <sjgengo@aboutfortunate.com> wrote in message
news:u%23vZ4a%23UDHA.3376@tk2msftngp13.phx.gbl...

> Graham,
>
> The ldb file will eventually time out. It takes a while though. I'll see

if

> I can find any way to set it's timeout period to be shorter, but my guess

is

> that it may be tied to the session object which would have a timeout

period

> of 20 minutes by default unless set otherwise. I'll experiment a little

and

> see if this is the case.
>
> --
> S. Justin Gengo, MCP
> Web Developer
>
> Free code library at:
> [url]www.aboutfortunate.com[/url]
>
> "Out of chaos comes order."
> Nietzche
> "Sabre" <maximNOSPAM@wave.co.nz> wrote in message
> news:uXKULC9UDHA.1680@tk2msftngp13.phx.gbl...

> > Hello All
> >
> > For some reason my Access XP record locking file is not clearing. Even

if

> I

> > use Explorer and manually open the mdb and then close it, ldb is still
> > there. Is there any way to delete the file using Explorer or other

means?

> > Any thoughts on why ldb sticking? (I'm opening database in code, with
> > password).
> >
> > Thanks!
> > Graeme
> >
> >

>
>

[vMike]

You might also try disposing you connection instead of closing it .. in the
form yourconn.dispose()
You may already be doing this but just in case.

"Sabre" <maximNOSPAM@wave.co.nz> wrote in message
news:uXKULC9UDHA.1680@tk2msftngp13.phx.gbl...

> Hello All
>
> For some reason my Access XP record locking file is not clearing. Even if

I

> use Explorer and manually open the mdb and then close it, ldb is still
> there. Is there any way to delete the file using Explorer or other means?
> Any thoughts on why ldb sticking? (I'm opening database in code, with
> password).
>
> Thanks!
> Graeme
>
>

[Sabre]

Thanks Both. I'll have a go at Dispose. Graeme
"Sabre" <maximNOSPAM@wave.co.nz> wrote in message
news:uXKULC9UDHA.1680@tk2msftngp13.phx.gbl...

> Hello All
>
> For some reason my Access XP record locking file is not clearing. Even if

I

> use Explorer and manually open the mdb and then close it, ldb is still
> there. Is there any way to delete the file using Explorer or other means?
> Any thoughts on why ldb sticking? (I'm opening database in code, with
> password).
>
> Thanks!
> Graeme
>
>

[Dan Vallejo [MSFT]]

Close the connection after using the database.

try
{
Open your database
do database stuff
}
catch (handle your exceptions)
{
}
finally
{
close database
}

aspnet_wp.exe is usually holding the database. If you use task manager to
close down that exe it will clear the database locks. IE is not holding the
lock because IE isn't opening the database. ASP.net is doing it.

Dan Vallejo, Visual Studio and .NET Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

>Reply-To: "S. Justin Gengo" <sjgengo@aboutfortunate.com>
>From: "S. Justin Gengo" <sjgengo@aboutfortunate.com>
>References: <uXKULC9UDHA.1680@tk2msftngp13.phx.gbl>

<uzZlagHVDHA.2364@TK2MSFTNGP09.phx.gbl>

>Subject: Re: access ldb
>Date: Mon, 28 Jul 2003 08:58:23 -0500
>Lines: 43
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <#aoZRBRVDHA.2052@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host: host8.krause.com 209.103.218.74
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:162591
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>Sabre,
>
>Let me know if dispose works for you. I set up a test access database and
>tried using the dispose method but the .ldb file still didn't clear.
>
>I think you might have to call the garbage collector yourself, but it's my
>understanding that you need to be very careful if you do so.
>
>Sincerely,
>
>--
>S. Justin Gengo, MCP
>Web Developer
>
>Free code library at:
>[url]www.aboutfortunate.com[/url]
>
>"Out of chaos comes order."
> Nietzche
>"Sabre" <maximNOSPAM@wave.co.nz> wrote in message
>news:uzZlagHVDHA.2364@TK2MSFTNGP09.phx.gbl...

>> Thanks Both. I'll have a go at Dispose. Graeme
>> "Sabre" <maximNOSPAM@wave.co.nz> wrote in message
>> news:uXKULC9UDHA.1680@tk2msftngp13.phx.gbl...

>> > Hello All
>> >
>> > For some reason my Access XP record locking file is not clearing. Even

>if

>> I

>> > use Explorer and manually open the mdb and then close it, ldb is still
>> > there. Is there any way to delete the file using Explorer or other

>means?

>> > Any thoughts on why ldb sticking? (I'm opening database in code, with
>> > password).
>> >
>> > Thanks!
>> > Graeme
>> >
>> >

>>
>>

>
>
>

--
Dan Vallejo, Visual Studio and .NET Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
[url]http://www.microsoft.com/info/cpyright.htm[/url]