views:

249

answers:

2

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.

A: 

This probably isn't exactly the answer you're looking for, but why not keep Access 2003 + Developer Extensions installed side by side with Access 2007 and just use 2003 to script the mde process?

Tim Lentine
A: 

This is also not what you are looking for, but why not use AutoHotKey to do the manual steps you mentioned but through a HotKey?

(I know it sounds like a hack, but it should work well nonetheless.)

IronGoofy