Solve MS Access Error ? Broken Reference to the File

: Emergence of an error message that states, “broken reference to the file…” when you access your Microsoft Access database can happen due to many possible reasons. Some of them are as follows:

Virus infection in the system
Abrupt system shutdown
An incompatible database element
Importing invalid database component
Corruption in the Operating System
Software malfunctioning etc

 

: When the above-mentioned error appears on your screen, it can cause inaccessibility of your Access database and therefore, your valuable data can be at stake.

 

: When you attempt to import a database component from a previous MS Access version (say 2003) to a newer MS Access version (say 2007), you will encounter the error message stating: “Your Microsoft Access database or project contains a missing or broken reference to the file version.” After such error occurs, your Access database is forced to shut down unexpectedly. When you attempt to re-mount it, you will not be able to do so. Further, the database becomes inaccessible & unmountable.

]]>

: To solve error broken reference to the file, follow the following steps:

: You can recover your Access database contents from an updated backup. However, if such updated & valid backup is not available, then you can go for other recovery methods.

 

: You would need to repair or recreate the corrupt Access MDB database relationships.
In case of small database: You can easily and quickly recreate all the relationships.
In case of large database: You cannot recreate all the relationships again. In this case, you have to Compact Access database, which can be done with the help of a third-party Access recovery tool. SysTools Access Recovery software is one such tool. It has been found that many users have been successfully using this product for  . So this software can perhaps be the perfect Access recovery solution for you to fix broken reference to the file error.

SysTools Group is a chief software development company that specializes in producing software tools for data recovery and other associated data needs of users across continents. The products are highly simple and intuitive to use. SysTools   Access Recovery tool is one of the software offerings of the company. This software can be conveniently used to solve error – broken reference to the file.

Source: ArticlesBase.com