Compile an Access MDE

[Carlitos]

How do I compile an Access MDE and what does it become (an EXE)?

 

[Rick Brandt]

How do I compile an Access MDE and what does it become (an EXE)?

You don't. You create an MDE from an MDB. The resulting MDE has all the VBA code
compiled and the source stripped out. Once you have an MDE that's it. You cannot
make an EXE out of it. It still needs MSAccess.exe to run. The main purposes for an
MDE is to protect your code and to increase performance.

 

[Carlitos]

Rick,

Thanks for the tip. I knew you can't have an EXE out of a MDB.
Nevertheless, I frequently see people making reference to "compile the
Access mdb", and I have always assumed that they don't mean really compiling
it but making a pseudo-compile of a mdb. Just wanted to make sure.

Thanks.