Resolving 'an Error Occurred While Loading Form_formname...' Error While Upgrading To Access 2003

In Microsoft Access, you can enter data into tables in a quick and easiest way by using forms

. You can create three types of forms in Access viz data entry-forms, switchboards and custom-dialog boxes. Thus, form is an important part of Microsoft Access database. At times, when you try and upgrade to a recent version of Microsoft Access, you may receive an error. As data becomes inaccessible, it becomes imperative for you to look for Access recovery strategies. You can use an updated backup to restore the corrupt database or use Compact and Repair inbuilt utility. If nothing works in your favor or you don't get the required results, it is recommended you switch to a third-party repair software.

Consider a practical scenario, wherein, you attempt to convert an Access 2002 (XP) database to Access 2003, you may receive the following error:

An error occurred while loading Form_FormName. Do you want to continue?

And, if you click Yes, you receive another error message which goes like:

Invalid procedure call or argument

Cause

The above error suggests that Microsoft Access 2002 (XP) database is corrupt.

Resolution

You can try the following Access database recovery steps in order to fix the problem:

Since Access 2002 and Access 2000 use different binaries for compile code, a decompile may work. (Microsoft Access keep two copies of the code i.e. text version and compiled version, if both are out of sync, you may come across strange errors. In such scenarios, a decompile helps by dumping the compiled version.)

1.Make a copy of the .MDB file while Access is not running

2.Use the Compact and Repair tool

3.Close Access. Open a command prompt and enter the following

C:Program FilesMicrosoft officeofficemsaccess.exe" /decompile "c:My DocumentsMyDatabase.mdb

4.Again Compact

5.Try the conversion again, the error may not surface this time.

If you are not able to overcome the nagging problem, do not worry, go to the Internet and download a professional access repair utility. Such utilities are able to repair an MS Access database when it is not compiled or if it has got corrupted due to an external reason.

by: jeny

POST COMMENT

Does Testing Power Up Software Developed Spanish Verb Training Software, Luxury or Neccessity? When And Why To Use A File Eraser Software Software Catia V5 CAD/CAE Fixing ...pst Can Not Be Accessed 0x80040116 Error In Microsoft Outlook Tips To Choose Seo Software Is It Worth Buying Affiliate Software? File Recovery Software – Recover data from a hard drive safe and easy! HP UNIX recovery after error "Can not read superblock Economic data recovery software – What are your options New Info - Attention International Terrorists; Most Cia From Usa Are Easy To Spot They Are Gay Change The Moment With Oclock Software! The Coming Software Developer Employment Boom - Special Report