How to recover Yes/No fields from Access database?

We know that two values – Yes and No are provided in a Yes/No field in Microsoft Access 2007 database. Basically, Yes/No fields are used as true/false values in databases. These fields can be in form of check boxes, option buttons, drop down menus and toggle buttons.

Whenever there is a corruption in Access .MDB database, the Yes/No fields also get corrupt.

What cause the database file to get corrupt?

Main reasons for corruption in Access database are MS Office malfunction, operating system corruption, abrupt system shut down, and malicious software like virus, etc. But one can resolve the corruption issue using some methodologies discussed ahead.

Resolution

To resolve the error message and access Yes/No fields, use inbuilt repair utility known as “Compact and Repair”. Follow the given below steps to compact and repair the database.
Compact and Repair Database.> Database utilities > Go to Tools menu

Select the corrupted database file in ‘Database to Compact From’ dialog box.

Click Compact.

Select a new location in the ‘Compact Database Into’ dialog box to store repaired file

Provide a new name to repaired database.

Click Save.

With above procedure you can again access the Yes/No fields in MS Access database. However, in some cases this utility doesn’t work well due to high degree of corruption. In that case you can use Access database repair tool that completely repairs Yes/No fields along with auto number, hyperlink, and OLE fields, etc.

Comments are closed.