How to compile an Access program?

[Guest]

Hi everyone,

I am using Office 2003. When we finish writing an access program, how can we
compile it into an EXE file? So we can install it like a Windows program.
Thanks.

 

[Paul Overway]

You can't. You can compile your database to an MDE, but you still need to
install Access...retail or runtime...in order to run an Access application.
You can distribute the runtime version of Access by using the Access
Developer Extensions...which is part of Visual Studio Tools for Office.

 

[Guest]

Hi Paul,

Thank you very nuch for your tips. I have once tried to convert my database
to a MDE but fail. I do not know why. Because I use Access 2000 in my office
and Access 2003 at home. If I code at home then I have to convert the
database to 2000 to use in my office. If I code in my office then I have
convert it to 2003 to use at home. So I can not make a MDE under access 2000,
I think the problems may come from the library I refer to. The other thing is
that I put some APIs and Addins in my database, will these prevent me to make
a MDE? Is Access XP the same as Access 2002?

 

[Guest]

I ran into this problem and found that if I opened a module and then selected
"Compile" from the menu - it would show me a section of code that was either
no longer needed or incorrect. Once I fixed it, it would allow me to create
the mde file.