.ldb problem in Access

Posted on 2005-05-05
Last Modified: 2011-10-03
access 2000, vbscript, asp, dw mx

This is fresh install on a new development machine.  I used to know how to do this, but then again one only does it every now and then.  There's a trick to this, but I've forgotten.  

Even though I close my record set and set the variables to nothing at the end of my asp page, I still have a persistent .ldb that will only go away after I reboot.  I cannot open the db exclusively using access if the web page has opened it previously.  There are no other uses.  

How do I 86 the ldb?  
Question by:rhkennerly
    LVL 7

    Assisted Solution

    I had an error like this once but it was because I had made a mistake in the code and the programming wouldn't get to the point where it closed. Does the webpage load and run properly?


    Author Comment

    It does.  Most curious.
    LVL 7

    Expert Comment

    Does the page enter information into the database? That's how I found out mine was broken. The page would load, everything looked ok, but no data would enter in the database and it wouldn't close. You might double check your code for an extra space or a ; in the wrong place.

    That's really all the help I can offer. Sorry.
    LVL 6

    Accepted Solution

    the ldb file is create when a connection is opened.  Make sure yo uclose the connection when you are done.

    Recordset.Close           ' where recordset is the name of the recordset
    Set RecordSet = nothing
    Connection.Close          ' where connection is the name of the connection
    Set Connection = nothing

    This will also kill the ldb file.
    LVL 6

    Expert Comment

    have you looked at the LDBView utility?
    it could give you more informations;en-us;176670
    LVL 5

    Assisted Solution

    Have you got Dreamweaver open? Close any dev pages in Dreamweaver and the file goes away if this is the case

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    Dreamweaver CS6 FTP issues 12 1,278
    thumbnails in content 11 290
    Coldfusion connection with xampp2 5 204
    Adobe Muse CC instead of Adobe Dreamweaver CC? 8 43
    I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
    Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now