System-related problems resulting in Access database corruption
by Colin Dolly
One of the most common factors for Microsoft Access database corruption is
damage in your computer system. The damage can occur due to numerous
logical and physical factors, resulting into inaccessibility of records
stored in your database. For complete access of database records in such
situations, always try to restore the data from a complete and valid
database backup. But if in case, the backup is unable to perform complete
restoration and the required records are missing, then you will need to
use advanced third-party access database repair applications, which can
comprehensively repair your corrupted database.
Few most common system-related issues that can result in MS Access
database corruption are:
Incorrect virtual memory settings Incorrect file-system settings
Incompatible or corrupted video driver A printer driver or settings
problem Hard disk fragmentation or disk errors A memory conflict Incorrect
or crowded Temp folder
Data stored in your Access database becomes inaccessible after it gets
corrupted due to any of the above problems. To resolve the Access database
corruption, you will need to use an inbuilt repair utility named "Compact
and Repair". The steps used in compacting and repairing the database are
discussed below:
1.Choose "Database Utilities" on the Tools menu, and then click Compact
and Repair Database. 2.Locate the database in the 'Database to Compact
From' dialog box, and then click Compact. 3.Choose a correct folder
location for the new file in the 'Compact Database Into' dialog box.
4.Provide a new and unique name for the file and then click on Save.
The repair utility repairs your database in most cases. But if in case,
the utility fails to repair your database, then you will need to opt for
powerful repair access application. Such Access Repair tools repair your
database corrupted due to system related issues. These tools employ
intensive scanning techniques to repair your corrupted database. Built
with highly interactive user-interface, these tools can be easily
implemented by both technical and non-technical users.
About the Author:
Colin Dolly is a self employed Internet entrepreneur and product reviewer.
Our access recovery software completely recovers and
access repair
database components such as, views, tables, forms, queries, macros, etc.
This
access recovery application supports Access 2007, 2003, XP and 2000.
Source:
http://www.goarticles.com