Hi,

I was writing code in my database and it stopped working. I can't open it up now at all. There is an .ldb file on my desktop now. Does anyone now why it is there or if I can do anything to open the db back up?

Thanks,
David

Step 1. Make certain that EVERYONE is loggrd out of the database.
Step 2. If the .ldb file is still there, delete it.



Rand

Thanks for replying rgerald!

I'm developing the database, so no one else logs into it.
I tried deleting the file, but then when I tried to open the db again the file would show back up.
I opened the ldb file up with notepad and it showed my pc name. I found a few things on the internet and they said this means the db is corrupt.
I ended up opening a new access db and importing everything from the corrupt db into the new one and it works fine now. It had me sweating it for a bit though.

Whenever you open an mdb file, the ldb file is created in the same folder. This file tracks current users for the database. So the fact that the ldb file was on your desktop indicates that the mdb file you are working on is also on your desktop. This is normal behavior for Access. The locking up is not.

If there is no one else in the database, then you can just delete the ldb file as rgerald suggests.

While you are developing, you should go to Tools > Options > General and select Compact on Close. This will clean things up between development sessions. You want to uncheck this when you are done developing since it could take a long time to compact, unless that database is split, then it shouldn't add additional close time.

Also, periodically do a Compact and Repair Database to clean up after your coding. Notice the how the file size increases as you develop, and shrinks significantly after you compact and repair.

Hope that helps.


mmcdonal

If after eliminating the old lock (.ldb) file, there is still a problem. Try doing a compact and repair on the database. Menu: Tools / Database Utilities / Compact and Repair Database


Rand

Thanks for the suggestions guys.

I had actually just done a compact/repair about 2 or 3 hours before the db locked up. I did find that I had an endless loop in my code once I got it imported into the new db. The loop was easily correctable though and I'm not sure why it would have messed up the db.
I had tried deleting the ldb file several times before I gave up on the db. Each time I deleted it then I clicked on the db to open it, but it locked up and put the ldb on my desktop again.

In regards to the .ldb file showing the PC name of who has the db open (if opened in notepad), does anyone know why the .ldb file would NOT show the PC name of who has the database open? My back-ends are up on our network, and sometimes it will show who has them open, and other times it will not. If it will not show me who has it open, I have to attempt a compact & repair on the back-end so it will error out and tell me it can't because user (PC name) has the database open. Then I'm getting people out one at a time until it will finally compact so I know I'm the only one in the back-end.

This isn't really a problem for me...its more of a nuisance and I thought I would ask.

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Hi Laura

I have a great little program that reads these *.ldb files. I have it on my computer at work, i will investigate and post a link for you to download

Cheers
Darren

Hello Again

The program is called ldbview.exe if you google this it will show you where you can download it, i got mine from microsoft website. i doesn't allow you to close open files but at least it shows you who is logged into the ldb file.

P.S sorry i took so long getting back to you

Cheers

Darren