Thursday, September 24, 2009

MS Access 2007 database corrupted with Samba 3.3.2

Microsoft Access database can be corrupted due to application malfunctioning, operating system corruption, file system damage, concurrent modification of database by two or more users, malicious software like virus and more. In most of the above cases of Access database corruption, the database becomes unmountable and data saved in the database becomes inaccessible. In the absence of an up-to-date and valid data backup, you will need to use advanced Access Repair applications for absolute repair and restoration of lost data.

Consider a practical scenario, where you create a new Access database (named Accounts) that maintains the salary records for all the employees in the organization. However, when you attempt to open Accounts database with Samba 3.3.2 server, the database gets corrupted.

The database corruption further results in making all the salary records inaccessible. The main cause for the corruption of Accounts database is the use of Samba 3.3.2 application to mount the database. A Samba 3.3.2 server is open source software that allows file and print sharing between Windows and UNIX computers. The damage primarily occurs because your system is not properly configured to use Samba 3.3.2 server. To prevent the damage of MS Access database in such scenarios, avoid opening your database with Samba 3.3.2 server.

Resolution:

To resolve the above issue and access the Accounts database, you will need to use an inbuilt utility known as “Compact and Repair.” To use this utility in Microsoft Office 2007, you need to follow these steps:

Click on Microsoft Office button.
From the Office menu, click “Tools”, select “Database Utilities”, then “Compact and Repair Database.”
MS Access will display the "Database to Compact From" dialog box. Navigate to the database you wish to ‘Compact and Repair’ and then click the Compact button.
Provide a new name for the compacted database and then click on the Save button.

But, if the above steps are unable to repair the Accounts database, then you need to opt for advanced access repair applications to systematically scan and repair the database.

These Access Database Repair tools employ high end scanning algorithms to completely repair and restore all corrupted Access database components. Such recovery tools enable you to comprehensively recover and restore both (.accdb and .mdb) Access database file formats. With self-explanatory and interactive user interface, these repair tools serve as easy-to-understand applications.

Access Recovery is the most reliable access recovery utility. It repairs and restores all Access database components such as queries, forms, reports, macros and modules. This Access Database Repair utility supports Microsoft Access 2007, 2003, XP (2002) and 2000. It is compatible with Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment