Friday, November 27, 2009

Modifying Columns results in “Invalid Bookmark” Error message

Modification in Microsoft Access database is a regular process performed by the user to keep their database up-to-date. While few modifications in the database records can be done directly, large amount of database records changes require SQL queries. An error message after SQL query execution primarily occurs in case your database becomes corrupt. In such situations, your SQL database records become inaccessible and you require a valid database backup to access your records. However, in case of no database backup availability or backup failing short to restore database records, you will need to use advanced third-party access database repair application.

Consider a practical scenario, where you modify the some columns of your Access database (Accounts) using a SQL query. However, after the modification process is finished, and you attempt to mount your database, you receive the below error message:

“Invalid Bookmark”

The records stored in your Accounts database becomes inaccessible after the above error message appears. Furthermore, the error message appears each time you attempt to access your database.


The root cause for the occurrence of the above error message is corruption or damage in Accounts database.


For absolute troubleshooting of the above error message and access of Accounts database records, you will need to Compact and Repair your Accounts database. To do so, you will need to follow the below steps:

Go to the Tools menu and select Database utilities
Click Compact and Repair Database option.
Search and select Accounts database file in the ‘Database to Compact From’ dialog box
Click Compact.
Select a new location for the repaired Accounts database file in the ‘Compact Database Into’ dialog box
Type a unique name for new repaired Accounts file (For example, New_Accounts)
Click on Save.

While the repair utility will repair Accounts database in most situations, it fails to repair in case Accounts database is too large or is severely corrupted. In such situations, you will need to repair Accounts database by using high end access repair tool. Such Access Repair tools provide safe repair of Access database after all kinds of logical corruption scenarios.

No comments:

Post a Comment