Unexpectedly Closing of database in Design View

While we are using MS access, the fastest and easiest way to create a query is use of Design view. For creating query using design, you have to follow some steps such as go to the Show Table dialog box, to select a table, you can click it and click the Add button, or you can double-click the table. As this method is easy for creating table in compare to form view but sometime user face some error messages such as:

The operation on the Chart object failed.

The OLE server may not be registered.

Even your data get corrupted and unexpectedly closes when you open query in design view. Interestingly, it doesn't crash if you run the same database and open it in form view! This error may come due to database corruption and one more issue is nameAutocorrect option. The problem is almost certainly caused by Name AutoCorrect - a "feature “where Access is supposed to keep track of things when you rename them, and
let your database keeps working with the new name. But the feature only works partially, and when the names don't match completely, your database is corrupted. It may possible that there is some changes in field name in table.

To workaround for this problem you should check the table and check for field name in a table. Then check if there is any modification in field name then it should update in query. We can get away from this error by fixing query but sometime it cause database corruption and database is unable to open. If this error comes due to NameAutoCorrect option then turn off this operation using following tab:

To turn it off, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Then compact the database to get rid of this:
Tools | Database Utilities | Compact.

If still you are facing this problem and database unexpectedly closes then there is serious database corruption. In this situation you need an access repair utility which can repair your database as previous. As we know compact and repair utility can fix some error but it has some limitations so in this situation we can’t rely on this. We can have a try with latest jet Hotfix pack to fix this problem.

In any case, Jet hotfix pack is not able to repair your database, don’t panic we have solution for you is Stellar Phoenix access recovery software. This utility scans your database using advance algorithm and repair your database, fix errors. Best thing about this access database repair utility is it repairs queries, forms, reports, macro, modules and primary key fields, if present.