Professional Web Applications Themes

access ldb - ASP.NET General

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" <maximNOSPAMwave.co.nz> wrote in message news:uXKULC9UDHA.1680tk2msftngp13.phx.gbl... > Hello All > > For some reason my ...

  1. #1

    Default Re: access ldb

    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" <maximNOSPAMwave.co.nz> wrote in message
    news:uXKULC9UDHA.1680tk2msftngp13.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
    >
    >

    S. Justin Gengo Guest

  2. #2

    Default Re: access ldb

    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" <sjgengoaboutfortunate.com> wrote in message
    news:u%23vZ4a%23UDHA.3376tk2msftngp13.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" <maximNOSPAMwave.co.nz> wrote in message
    > news:uXKULC9UDHA.1680tk2msftngp13.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 Guest

  3. #3

    Default Re: access ldb

    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" <maximNOSPAMwave.co.nz> wrote in message
    news:uXKULC9UDHA.1680tk2msftngp13.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 Guest

  4. #4

    Default Re: access ldb

    Thanks Both. I'll have a go at Dispose. Graeme
    "Sabre" <maximNOSPAMwave.co.nz> wrote in message
    news:uXKULC9UDHA.1680tk2msftngp13.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 Guest

  5. #5

    Default Re: access ldb

    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" <sjgengoaboutfortunate.com>
    >From: "S. Justin Gengo" <sjgengoaboutfortunate.com>
    >References: <uXKULC9UDHA.1680tk2msftngp13.phx.gbl>
    <uzZlagHVDHA.2364TK2MSFTNGP09.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.2052TK2MSFTNGP10.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" <maximNOSPAMwave.co.nz> wrote in message
    >news:uzZlagHVDHA.2364TK2MSFTNGP09.phx.gbl...
    >> Thanks Both. I'll have a go at Dispose. Graeme
    >> "Sabre" <maximNOSPAMwave.co.nz> wrote in message
    >> news:uXKULC9UDHA.1680tk2msftngp13.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]

    Dan Vallejo [MSFT] Guest

Similar Threads

  1. Web Service + Anon Access, but getting 401 Access Denied Error
    By Alex Washtell via .NET 247 in forum ASP.NET Web Services
    Replies: 1
    Last Post: April 5th, 04:57 PM
  2. Network File access using anonymous access
    By Tim Menninger in forum ASP.NET Security
    Replies: 2
    Last Post: July 22nd, 03:37 PM
  3. Access 2002 PDFWriter VBA Code w/WinXP does not work like Access 2000
    By Tony_VBACoder in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 30th, 07:44 PM
  4. Replies: 0
    Last Post: December 16th, 06:19 PM
  5. Access denied when creating Access application object
    By Bill Murphy in forum ASP Database
    Replies: 7
    Last Post: July 31st, 05:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139