Compiling entire MS Access database

[Mike Anderson]

I need to compile the entire MS Access database. I think
Microsoft calls it MDE? Does anyone know how to do that
or have a link?

Thanks!

 

[Immanuel Sibero]

Hi Mike,

In Access 2000, it's right there under the Tools menu. Click on
Tools>>Database Utilities>>Make MDE File.

An access database (.mdb file) can not be compiled to a completely
stand-alone application. The application development tool used in Access is
VBA which is an interpreted language so it needs something else to run - the
"retail" version or the "runtime" version of Access. The term "compiling"
has been used rather loosely to describe the creation of an MDE file from an
MDB, but an MDE file by itself would not run without the retail or runtime
version of Access.

Compiling in this case is not the same as the traditional meaning of
compiling a C++ program to an executable file (i.e. exe or com). So in the
strictest meaning of the word, you can not compile an Access MDB file.
Creating an MDE simply removes the VBA code from the MDB file so other
people can not snoop around your code.


Immanuel Sibero

 

[Marin Kostov]

You will need the Microsoft Office Developer's edition!
With it you can make stand-alone applications, and distribute them to users,
which do not have Access installed on their computers.