About this Article:
Over time, the part of your Access database that stores VBA module code can become bloated and, in some cases, can cause strange or otherwise unexplained behavior. As you compile and run code, VBA leaves behind old states of code that are no longer valid. Often, the Access Repair and Compact operation doesn't free up this space. To solve these problems, use the undocumented Decompile command line switch for Access.
Keyword Tags: Database, Database Development, Microsoft, Microsoft Access, Microsoft Jet, Microsoft Office, Microsoft Windows, Microsoft .NET, Microsoft .NET Framework, Performance, Software Development, VBA