Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 21st, 2005, 12:16 AM
Registered User
 
Join Date: Apr 2005
Location: Dhaka, Bangladesh, Bangladesh.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Access .mdb & .ldb database corrupted

Dear P2p Community Forums,

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl after restart the pc i couldn't open the A.mdb file. The message shown A.mdb database is corrupted. A.mdb database was password lock but after corrupted if i give the valid password the database not open and showing the password not valid. Now i couldn't open the database. Now it shown A.mdb file with A.ldb file. Please advise me if pc shutdown with the connected .mdb databae then why the database not recover after restart? Also i tried with the option Database Repair and Recovery.

Please advise me and thanks again for your kind co-operation.

Best Regards
Faisal Ahamed
faisalpcs@bdonline.com; faisal573@yahoo.com
Reply With Quote
  #2 (permalink)  
Old April 21st, 2005, 12:25 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I don't know if this will help, but I have experience similar problems in the past, which have been resolved by simply deleting the .ldb file. This will clear the lock on the mdb file and should allow you to get in and try and recover your data. Having had several cases where the database has been corrupted past my abilities to recover from, I now make a backup of the database either daily or whenever I make a major change - I always have to redo some work, but over all it makes recovery a lot simpler.

Good Luck,

Mike

Mike
EchoVue.com
Reply With Quote
  #3 (permalink)  
Old September 13th, 2006, 01:19 AM
Registered User
 
Join Date: Sep 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As your A.mdb files exists in the same location but it is inaccessible, in this case you need to repair your access database, to repair your corrupted access data base you have to choose best Access Database Recovery Software

To repair your corrupted access database use Kernel Recovery for Access

I have visited many databas recovery websites and evaluated many database recovery software.
But my experience with Kernel Recovery for Access is almost excellent.

I used this tool when my sales.mdb or sales database got corrupted and showing error message like "The Microsoft Jet Database Engine cannot open the file". This tool helped me a lot to retrieve one of my important database.

BINGO!!! I get my database back without any problem...

The software is available for downloading its DEMO version which allows you to preview the recoverable contents of the corrupted database.

Really a great piece of software...........

thanks


Reply With Quote
  #4 (permalink)  
Old September 13th, 2006, 12:18 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Oh great, a sales pitch. Thanks recoveryguru, I really thought you were not a sales person for a minute there - NOT.

Anywho, deleting the ldb should allow you to reopen the file, as echovue says. If not, then you can try the local repair tools built in to Access.

HTH

mmcdonal
Reply With Quote
  #5 (permalink)  
Old September 13th, 2006, 09:57 PM
Authorized User
 
Join Date: Apr 2006
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try repair and compacting the database first before you delete the ldb. but deleteing the ldb usually works to unlock your database.

Reply With Quote
  #6 (permalink)  
Old September 13th, 2007, 12:04 AM
Registered User
 
Join Date: Sep 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

For repairing corrupted .mdb files there is one more option Stellar Phoenix Access Recovery. This data recovery software does a complete scan of the corrupted access files. After that, access files are repaired and restored to a default location or to a user specified folder.
The demo version can be downloaded from: http://www.stellarinfo.com/access-recovery.htm
Demo version shows the preview of repaired database.

Reply With Quote
  #7 (permalink)  
Old March 3rd, 2008, 08:13 AM
zyl zyl is offline
Registered User
 
Join Date: Mar 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi, faisal573

You can try a popular Access database recovery tool called Advanced Access Repair to repair your Access MDB file. It is a powerful tool to repair corrupt or damaged Access MDB files.

Detailed information about Advanced Access Repair can be found at http://www.datanumen.com/aar/

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan
Reply With Quote
  #8 (permalink)  
Old December 9th, 2009, 03:44 AM
Registered User
 
Join Date: Dec 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Why not try Advanced Access Repair at http://www.datanumen.com/aar/ ? It recovers several important Access MDB files for me and is really helpful!

W.D
Reply With Quote
  #9 (permalink)  
Old February 1st, 2012, 04:48 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Repair MS Access database

Access file recovery is the system utility program that can perfectly repair ms access database and reconstruct mdb file and accdb file. software also repair all version of ms access database speedly..

Thanks
Josaph
Reply With Quote
  #10 (permalink)  
Old July 17th, 2013, 02:48 AM
paiyaan
Guest
 
Posts: n/a
Thumbs up Recover corrupt MS Access .mdb file

To repair a corrupt .mdb database of MS Access, one can try Compact and Repair feature of MS Access. It repairs corrupt database and makes it accessible for database users. Other than this one can also use import feature of MS Access that helps database users import their corrupt database to a new database file. If both these solutions fail to fix this corruption, then one must check some third-party access database repair or recovery software. I would like to suggest SysInfoTools MS Access Database Recovery software here to repair corrupt .mdb and .accdb files. One can check its free demo version before buying its full version. Download the software from this page: sysinfotools.
Hope this would be helpful.
Reply With Quote
The Following User Says Thank You to For This Useful Post:
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupted mdb file edcaru Access 4 April 19th, 2012 10:38 AM
conversion of ms access .mdb to .exi GeoIrshad Access 2 March 11th, 2008 06:21 AM
MS Access .mdb calling SQL server 2000 stored proc fazzou Access 6 September 8th, 2006 11:32 AM
text like Ms Access mdb sal21 Excel VBA 0 May 6th, 2006 03:54 PM
Manage the .ldb file when ADO opens a Access .mdb marcelescu Visual C++ 1 October 18th, 2004 06:44 PM



All times are GMT -4. The time now is 11:52 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.