subject: Tips to Resolve “You have chosen to alter the mode...” Error Message [print this page] Author: colindolly Author: colindolly
Error messages at the initial stage of database startup (mounting an MS Access database) or while accessing the database can leave the database user into difficult situations. Such error messages primarily result in unmountability of database, which further result in inaccessibility of stored records. The root cause for occurrence of such error messages is damage in MS Access database. An easy way to access the database records in such situations is by restoring the data from an updated backup. While most of database users maintain a valid backup for their database, there are some who forget to do so. For them, a powerful third-party access file repair application acts as a boon. Consider a practical situation, where you receive the below error message while attempting to view the records using a query: You have chosen to alter the mode in which SQL syntax will be interpreted in this database. This will mean: Existing queries may return different results or not run at all. The range of data-types and reserved words will change. Different wild cards will be used. It is recommended that you make a backup copy of this database before continuing. If you agree to continue, Access will close this database, compact it, and re-open in the new mode. Select OK to continue. As the error message explains, the query will either display wrong results or not execute at all. Cause: Access Database corruption due to altering the mode. Resolution: The resolution as suggested in error message is to compact and repair the database using below steps: 1.Firstly, select 'Tools' (option available on the Toolbar Menu). 2.Now, select 'Compact and Repair Database' (option available under 'Database Utilities' list). 3.Click 'Database to Compact From' (to select the corrupt database). 4.Click 'Compact' (for beginning the repair process). 5.Click Save after providing a desired location to save the repaired database. Compacting and repairing the database resolves your issue in most corruption scenario. In case compacting and repairing process fails, you will need to use effective repair access file tool. An Access Repair application uses effective repairing algorithms, which comprehensively scan and repair the corrupt database.About the Author:
Colin Dolly is a self employed Internet entrepreneur and product reviewer. Our access recovery software completely recovers and access database repair database components such as, views, tables, forms, queries, macros, etc. This access recovery application supports Access 2007, 2003, XP and 2000.
