Monday, July 20, 2009

“Broken Reference to the File…” error in MS Access

An error message in MS Access database can be caused due to importing an incompatible or invalid database component, operating system corruption, virus infection etc. This error message does not allow the user to further access the database. In such situations, the user needs to recover the Access database from the latest backup. However, if the user has not created any backup of the inaccessible Access database, the user can repair and restore the Access database by using advanced Access Repair utilities.

As a practical scenario, when the user attempts to import a database component like form from Access 2003 to Access 2007, he encounters the below error message:
“Your Microsoft Access database or project contains a missing or broken reference to the file version
here signifies the name of the .dll or .tib file
here signifies the version number of the .dll or .tib file

After the above error message appears, the Access database closes unexpectedly. When the user attempts to remount the Access database, he is unable to do so. Furthermore, the Access database becomes inaccessible and unmountable. Two main reasons for the occurrence of the above error message are:

• The form in the source Access database contains a reference to a DLL (.dll- Dynamic Link Library) or to a type library (.tlb).
• The DLL (.dll) or the type library (.tlb) does not exist in the same location on the source computer.

To resolve the above issue and access the database, the user needs to repair or recreate the corrupted database relationships. Repairing a database relationship creates a reference of the file name to a library or an updated version of that library. In small Access database, the user can easily and quickly recreate all the relationships. But in case of large Access database, the user can not recreate all the database relationships again. In such scenarios, the user needs to perform repair by using powerful access repair application. The repair software performs MDB repair without modifying the original contents of the Access database. Such repair applications use influential scanning methods to repair the corrupted Access database.

Stellar Phoenix access recovery is the most powerful Access Repair application. It can easily recover Access database relationships. It can restore and Repair Access components like tables, queries, macros, modules, forms and reports. It supports Access 2007, 2003, 2002(XP) and 2000. It is compatible with Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment