How to Effectively Handle Damaged Macros or Modules in Access
The Compact and Repair utility of Microsoft Access is probably one of the most powerful features of the application giving users some assurance that their valuable data can always be recovered even if the database gets damaged. However there are limitations to this utility.
The utility tries to repair only the tables, indexes and queries in the damaged database and does not attempt to fix damaged macros or modules. Another disadvantage is that if the database is severely damaged, then this utility is not always able to make a successful restoration of the database. This is why all users are advised to make regular and frequent backups of their database, especially if they are making constant use of them. Of course, there are powerful tools such as Advanced Access Repair from DataNumen that can help recover MDB files, even severely damaged ones, without any problem.
If the problem in your database has got to do with damaged macros or modules then here are a few things that you could try to fix the problem. Before you try to deal with the damage to your macro or module, you should be aware that the damage could be in the actual macro or module, or it could simply be in the contents of the macro or module. The simplest option then would be to delete the existing macro or module, import it from the database backup copy just as you would to recover MDB data and continue using it. Else you could try the following options '
· If you suspect that the damage is in your macro or module, you could just create a new macro or module and then copy the undamaged contents of the original macro or module into it.
· Sometimes, the damage is because of non-ASCII characters creeping into the module. Try saving the file as a text file and then removing the illegal entries if any. Save the file and reload it into a new module.
· Finally, if none of these work, and the damage is in the content of the macro or module, you may have to not only create a new macro or module but also have to recreate the contents of the original macro or module.
Advanced Access Repair from DataNumen takes all the anxiety and drudgery out of restoring Access data. Amazingly easy to install and get going, this software can restore database objects that many tools find hard to even locate. With just one click of the button, you can start the recovery process, and restore even deleted tables and records. You can thus use Advanced Access Repair to swiftly and smoothly recover MDB data.