How to extract data from database?

[BillyFox]

Our office space is always filled many programmers. But I don't know why, today I couldn't open my Access database and no one of them I didn't find. My problem is usual, at opening MS Access 2007 showed... Microsoft Access has encountered a problem and needs to close. I tried to open .mdb file on another machine, but the same error appeared. I work on Windows 7 x32.

[jimatqsi]

Sometimes Access database can get corrupted. You may have no choice but to restore a backup copy. If you don't have one, you might be able to make a new database and link to the old one to extract forms, queries, reports etc.... Or, lacking that, you might find a commercial product that can fix corrupted Access database files.

Jim

[twinnyfo]

BillyFox,

Welcome to Bytes.

It is also wise to make sure that you have a Front-End and Back-End design to your DB. If at all possible, Users should open a Front-End that is downloaded to their local machine and executed locally, but accessing the Back-End from the network environment.

This Post on DB Updates is helpful in this design. However, Jim's advice is spot on.

Always make sure you create backups frequently with Access!

[jackel]

First to repair access data make a copy of your database file when Access is not running.

When an Access database file (mdb or accdb) is corrupt or damaged, then you can try several methods to repair and recover data from it:
1. First of all, try compact & repair. Follow below steps:
For Access 2010, click Compact and Repair Database on the Database Tools ribbon.
For Access 2007, click the Office button (top left), then Manage.
For Access 95 - 2003, choose Database Utilities from the Tools menu.
2. Second, if method 1 does not work then try to create a new Database and import all the objects from old database into new blank database.
3. If nothing works, then you may use Google, there I found interesting method, it might be useful in your complicated case.