| In Microsoft Access, you can enter data into tables in | | | | You can try the following Access database recovery |
| a quick and easy way by using forms. You can create | | | | steps in order to fix the problem: |
| three types of forms in Access viz data entry-forms, | | | | Since Access 2002 and Access 2000 use different |
| switchboards and custom-dialog boxes. Thus, form is | | | | binaries for compile code, a decompile may work. |
| an important part of Microsoft Access database. At | | | | (Microsoft Access keep two copies of the code i.e. |
| times, when you try and upgrade to a recent version | | | | text version and compiled version, if both are out of |
| of Microsoft Access, you may receive an error. As | | | | sync, you may come across strange errors. In such |
| data becomes inaccessible, it becomes imperative for | | | | scenarios, a decompile helps by dumping the compiled |
| you to look for Access recovery strategies. You can | | | | version.) |
| use an updated backup to restore the corrupt | | | | 1.Make a copy of the.MDB file while Access is not |
| database or use Compact and Repair inbuilt utility. If | | | | running |
| nothing works in your favor or you don't get the | | | | 2.Use the Compact and Repair tool |
| required results, it is recommended you switch to a | | | | 3.Close Access. Open a command prompt and enter |
| 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. |