question

IntisaarBangura avatar image
IntisaarBangura asked

access .mdb not opening

Not every day I stumble on such troubles. One of my .mdb files looks like damaged. I can't open it from yesterday morning. I've no idea what to apply.
databasemicrosoft-access
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

restore from backup?
1 Like 1 ·
AaishBaccus avatar image
AaishBaccus answered
This method [mdb restore][1] may help if your database is already corrupt or in case neither article nor mentioned links can't help you Here you may find solutions that are probably more effective than others - [ http://www.databasejournal.com/features/msaccess/article.php/1494111/How-to-Recover-a-Table-Deleted-from-an-Access-Database.htm][2] It is the resource of this article: [ http://allenbrowne.com/ser-47.html][3] Before doing anything else, make a copy of the corrupted mdb file while Access is NOT running, and without overwriting any earlier backups. This lets you try different approaches and sequences if necessary. Next, try the built-in repair utility. This very simple solution may work with corrupted indexes, and might even get rid of a corrupted object: • In Access 2010, click Compact and Repair Database on the Database Tools ribbon. • In Access 2007, click the Office button (top left), then Manage. • In Access 95 - 2003, choose Database Utilities from the Tools menu. If this does not work, follow the steps for the symptoms of your corruption below. [1]: https://www.restoretools.com/accessrestore.html [2]: http://www.databasejournal.com/features/msaccess/article.php/1494111/How-to-Recover-a-Table-Deleted-from-an-Access-Database.htm [3]: http://allenbrowne.com/ser-47.html
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

IntisaarBangura avatar image
IntisaarBangura answered
I don't have backup
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Also, if you have other databases in your environment, I would highly recommend you find a way to back them up regularly for just this reason. Do it now.
0 Likes 0 ·
jason_clark03 avatar image
jason_clark03 answered
You can use **Compact & Repair Utility** to repair corrupt MDB file. Have a look on this to [repair corrupt access database file][1]. If all above methods fail to fix corruption best option other than restoring from backup is to try a 3rd Party ware like [Access database recovery software][2] to repair MS Access database without hampering the original data within MDB / Accdb file. [1]: http://www.datarecovery.institute/repair-corrupt-ms-access-database-files/ [2]: http://www.accessrecoverytool.com/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.