Resolving “Run-time error ‘2004′…” Error message in Microsoft Access 2003 and 2002
Corruption of MS Access database can occur if you repeatedly open and close your database that includes group controls in one session. Group controls in Access database are primarily used to perform two or more operations included in one particular group. Data saved in the Access database becomes inaccessible after the database gets corrupted. In such situations, backup acts as a boon to restore your lost data. However, if no backup is available or backup falls short of restoring the required data, then you need to use advanced access recovery applications to recover the lost data.
Consider a practical case, where you encounter the below error message after you attempt to open an Access database (such as Department):
“Run-time error ‘2004′. There isn’t enough memory to perform this operation. Close unneeded programs and try the operation again.”
Data saved in the Department database becomes inaccessible after the above error message appears. In addition, you encounter the same error message each time you attempt to open the database.
Cause:
The Access database has been corrupted. To prevent the occurrence of the above error message, you should avoid frequent opening and closing of Access database that contains group controls.
Resolution:
To resolve the above error and access the Department database, you need to ungroup the controls. To do so, you will need to follow these steps:
- Open the form or the report.
- On the View menu, click Design.
- Click any control in the group to select the group.
- On the Format menu, click Ungroup.
However, if the above steps fall short to resolve the issue, then you need to use an inbuilt repair utility known as “Compact and Repair.” However, if the inbuilt repair utility fails to repair the Department database, then you need to opt for advanced access repair applications. Such Access Database Repair applications incorporate high end scanning methods to entirely recover all Access database components. These applications can recover and restore inaccessible Access databases. Equipped with interactive user interface, these recovery tools are self-explanatory applications which can be implemented without need of any prior technical skills.
Stellar Phoenix Access Recovery is a feature rich Access Database Repair tool. This tool can restore and Repair Access database components as queries, forms, reports, macros and modules. The software is designed for Microsoft Access 2007, 2003, 2002 (XP) and 2000. It is compatible with Windows Vista, XP, 2003, 2000 and NT.
colindolly 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 repair access application supports Access 2007, 2003, XP and 2000. Article Source:http://www.articlesbase.com/software-articles/resolving-runtime-error-2004-error-message-in-microsoft-access-2003-and-2002-947471.html
Leave a comment