.mdb database in access

Try to run a compact and repair and see if that works for you.

This method access repair database 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/featu...s-Database.htm

It is the resource of this article: http://allenbrowne.com/ser-47.html

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.

Hi,GabrielaSilva

Based on your description, your Access database is corrupt.

The Access database file format is very complex. It starts with a file header containing the meta information of the whole file, followed by several parts containing the actual data. You can find more detailed information about the Access database file format by searching on Google with the keyword “Access database file format”. If the file header containing the meta information is corrupt, or any follow-up parts are damaged or corrupted, then you will not be able to open the file correctly with Access. In such a case, the first step is to try to use the built-in repair or recovery function in the Access, to see if it can repair or recover the corrupt file. If not, then you need to resort to a third-party mdb repair software to scan the corrupted file and retrieve all recoverable data for you. It is also possible to find a data recovery expert or company to do the task, but in most of the cases, they will also use a third-party tool to do the recovery for you.

The main difference between using the software by yourself and by a third-party service company is:
(1) The company is familiar with the data recovery industry so he knows which software is the best one. While you need to search and compare the software online by yourself, which is time-consuming.
(2) The company purchases the software for multiple usages, while you purchase the software for one-time usage only. So normally the service fee may be cheaper than the license fee for the software.
(3) DIY will keep your data confidential while do the recovery via a company may cause data breach.

If you want to perform a DIY recovery, then you can first try the build-in "Compact and Repair" command in Access to repair your corrupt database, you can get more detailed info at:

http://office.microsoft.com/en-us/ac...010341740.aspx
http://databases.about.com/od/tutori...3-Database.htm

If the above method does not work, then you can try DataNumen Access Repair at:

https://www.datanumen.com/access-repair/

I have used the tool in the past and it helps recovering some valuable data for me. The tool has a free demo so that you can try to see if it works on your file or not before you buy.

Hope that helps! Good luck!

Run "Compact and Repair" utility, it will defiantly help you to resolve your issue.
shot-access-2013-668x348.gif