How do I create an Access 2003 MDE programmatically or by command line in Access 2007?
Posted
by Ned Ryerson
on Stack Overflow
See other posts from Stack Overflow
or by Ned Ryerson
Published on 2009-09-29T21:31:59Z
Indexed on
2010/04/22
8:03 UTC
Read the original article
Hit count: 592
I have a legacy Access 2003 database file that must remain in that format to preserve its menus and toolbars. I have recently moved to Access 2007 in my build environment and will be deploying the compiled Access 2003 program with the Access 2007 runtime. In Access 2003, I could script the process of creating an MDE with the Access Developer Extensions (WZADE.mde) using the command line and an .xml file of build preferences (without creating an install package). The Access 2007 developer extensions do not seem to offer a similar option. I can "Package a Solution", but it creates an accdr and buries it in a CD installer. I've tried programmatic options like Docmd.RunCommand acMakeMDEFILe and Syscmd(603, mdbpath, mdepath) but they no longer work in Access 2007. Of course, i can manually create an MDE using Database Tools>Create MDE, but that is no scriptable as far as I can tell.
© Stack Overflow or respective owner