Tuesday, October 20, 2009

Lost Images in MS Access database

Microsoft Access database allows you to save different types of images (scanned art, computer graphics, and digital pictures) on its various components like tables, forms, reports, and more. These images can either be embedded as the internal part of database file or can be linked to a network or hard drive. Inaccessibility of these images primarily occurs due to Access database corruption, network damage, and similar reasons. To overcome such situations, you can restore all the images from an updated backup. But if no backup is available or backup falls short to restore the required images, then you will need to opt for repair access software that can repair your database and recover all the images.

Consider a practical scenario, where you have embedded some static pictures (company logo and background images) in your financial report to make it more descriptive. However, when you open your financial report, the static pictures do not appear. Few most common reasons for disappearing of images are discussed below:

Access database corruption
VBA (Visual Basic for Applications) corruption

To access all your inaccessible images, you will need to take below actions:

Analyze VBA code used for displaying the static images.
If the VBA code is correct, then repair your database using “Compact and Repair” utility. To use the repair utility, follow the below steps:

1.Select Database Utilities under Tools drop down list. Click “Compact and Repair Database.”
2.Click Compact after searching and selecting the database in the ‘Database to Compact From’ dialog box.
3.Select a new folder location for the file in the ‘Compact Database Into’ dialog box. Provide a unique name to the file.
4.Click on Save.

The repair utility makes the images accessible in most cases. But if in case, both the resolutions fail to resolve your issue and your images still remain inaccessible, then you will need to use an advanced Access Repair tool that can recover all your lost images. Such access database repair tools use high end scanning methods to recover all your lost images. These recovery utilities are built with highly graphical user-interface that makes them easily understandable without any prior technical skills.

No comments:

Post a Comment