A Yes/No field in Microsoft Access 2007 database saves only two values – Yes and No. These Yes/No fields are primarily used as true/false values in databases and are displayed in check boxes, option buttons, and toggle buttons. Corruption or damage in Access database can result in inaccessibility of Yes/No fields. Few main causes for damage of Access database are MS Office malfunction, operating system corruption, and malicious software like virus. To access all the Yes/No fields after Access database corruption, an effective is to restore them from an updated and valid database backup. But, there have been thousands of examples where the database user has forgot to create a backup or its backup file has been corrupted. In such situations, the only way to recover Yes/No fields is by using advanced third-party access repair application.
Consider a practical example, where your Access database gets corrupted leaving all the Yes/No fields inaccessible. In addition, you encounter an error message each time you attempt to access Yes/No fields.
Resolution:
To resolve the error message and access Yes/No fields, you will need to repair your database using an inbuilt repair utility known as “Compact and Repair”. To use the repair utility, you will need take underneath steps:
· In the Tools menu, select Database utilities
· Select Compact and Repair Database option.
· 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.
The above steps enable you to repair your database in most cases and makes all the Yes/No fields accessible. However, there are some possibilities of the repair utility being unable to repair your database in case your database is severely corrupted or is too large. These situations force you to use an advanced Access Recovery software that can systematically recover Yes/No fields. These access database repair tools come with highly graphical user documentation that guide you through a complete process of recovering Yes/No fields.
Stellar Phoenix Access Recovery salvages and recovers Yes/No fields after all database corruption scenarios. Supported by Windows Vista, 2003, XP, and 2000, the non-destructive software repairs database built in Access 2007, 2003, XP (2002), and 2000, the Access Database Recovery tool also retrieves fields, such as, autonumber, hyperlink, and OLE fields.