Sunday, August 9, 2009

Resolving “Disk Space” error messages in MS Access

A page in MS Access database is the smallest amount of storage area. Modifications or alterations performed in Access database should be performed by temporarily locking all the pages it contains. This prevents database corruption as two or users may not be able to modify the database simultaneously. However, if the prevention is not taken and the pages remain unlocked, the probability for database corruption remains. The best way to overcome any type of corruption in the Access database is to restore the data from an updated backup. However, if no backup is available or backup fails to restore the required data, then you will need to use advanced access recovery applications that can completely repair the corrupted database.

As a practical case, you encounter any of the below error messages when you attempt to mount your Access database (Accounts):

"There isn't enough disk space or memory."
Or
"There isn't enough disk space or memory to undo the data changes this action query is about to make."

You encounter the same error message each time you attempt to mount the database. Data stored in the Accounts database becomes inaccessible after any of the above error messages appear.

Cause:

The root cause for the occurrence of the above error message is the exceeding of the 9,500 locks per database file limit. The above error messages primarily occur while mounting large databases. To prevent the occurrence of any of the above error messages, you will need to increase the default decimal value of 9500 in the Value Data field.

Resolution:

To resolve the above error message and access the database, you will need to need to make some changes in the Windows Registry. A slightest of mistake while making changes in the Registry can result in serious problems. To overcome all those problems and access the database, you will need to use advanced Access Repair applications. Such Access Database Repair utilities employ advanced scanning algorithms to comprehensively recover all Access database components. These applications can completely recover and restore inaccessible Access databases. Built with highly interactive and graphical user interface, these repair utilities are easy to understand without the need of any prior technical understanding.

Stellar Phoenix access database repair is a feature rich Access Database Repair application. This repair application can restore and Repair Access database components including queries, forms, reports, macros and modules. The read only software supports Microsoft Access 2007, 2003, XP (2002) and 2000. It is designed for Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment