| In Microsoft Access, you can enter data into tables in | | | | You can try the following Access database |
| a quick and easiest way by using forms. You can | | | | recovery steps in order to fix the problem: |
| create three types of forms in Access viz data | | | | Since Access 2002 and Access 2000 use different |
| entry-forms, switchboards and custom-dialog boxes. | | | | binaries for compile code, a decompile may work. |
| Thus, form is an important part of Microsoft Access | | | | (Microsoft Access keep two copies of the code i.e. |
| database. At times, when you try and upgrade to a | | | | text version and compiled version, if both are out of |
| recent version of Microsoft Access, you may receive | | | | sync, you may come across strange errors. In such |
| an error. As data becomes inaccessible, it becomes | | | | scenarios, a decompile helps by dumping the compiled |
| imperative for you to look for Access recovery | | | | version.) |
| strategies. You can use an updated backup to restore | | | | 1.Make a copy of the .MDB file while Access is not |
| the corrupt database or use Compact and Repair | | | | running |
| inbuilt utility. If nothing works in your favor or you don't | | | | 2.Use the Compact and Repair tool |
| get the required results, it is recommended you switch | | | | 3.Close Access. Open a command prompt and enter |
| to a third-party repair software. | | | | the following |
| Consider a practical scenario, wherein, you attempt to | | | | "C:\Program Files\Microsoft |
| convert an Access 2002 (XP) database to Access | | | | office\office\msaccess.exe" /decompile "c:\My |
| 2003, you may receive the following error: | | | | Documents\MyDatabase.mdb" |
| "An error occurred while loading Form_FormName. Do | | | | 4.Again Compact |
| you want to continue?" | | | | 5.Try the conversion again, the error may not surface |
| And, if you click Yes, you receive another error | | | | this time. |
| message which goes like: | | | | If you are not able to overcome the nagging problem, |
| "Invalid procedure call or argument" | | | | do not worry, go to the Internet and download a |
| Cause | | | | professional access repair utility. Such utilities are able |
| The above error suggests that Microsoft Access | | | | to repair an MS Access database when it is not |
| 2002 (XP) database is corrupt. | | | | compiled or if it has got corrupted due to an external |
| Resolution | | | | reason. |