How to extract/view/capture module/forms from Access mde file?  
Author Message
Perry Choy





PostPosted: Visual Basic for Applications (VBA), How to extract/view/capture module/forms from Access mde file? Top

I want to edit code module from Access mde file, due to i missing the source file Who can help me Thank you very much!

Microsoft ISV Community Center Forums3  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), How to extract/view/capture module/forms from Access mde file? Top

Hi Perry,

This cannot be done. When you run VBA code in MDB files the code is complied on the fly into, not machine code, but some other language that I can't remember the name of. It's like .NET code, which is compiled into IL, which is compiled again into machine code when its ran. VBA is the same, it's compiled into something I can't remember the name of, which is then compiled into machine code when it's ran.

When you make a MDE file the VBA code is compiled and stored in the database as the language I can't remember the name of which makes things run faster but it means you cannot edit it or export it, because it's no longer VBA.