Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


.ldb problem in Access

Posted on 2005-05-05
Medium Priority
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

Assisted Solution

MHenry earned 600 total points
ID: 13940014
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

ID: 13943951
It does.  Most curious.

Expert Comment

ID: 13945686
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.
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Accepted Solution

iscode earned 1000 total points
ID: 13950490
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.

Expert Comment

ID: 13950589
have you looked at the LDBView utility?
it could give you more informations

Assisted Solution

cokefour earned 400 total points
ID: 13967056
Have you got Dreamweaver open? Close any dev pages in Dreamweaver and the file goes away if this is the case

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

578 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