Programmatically creating mde file

[Peter]

Is it possible to create an mde file while controlling
Access programatically through automation? I thought I
would be able to do it with the runcommand method, but I
cannot find the appropriate constant. Perhaps it can be
done by calling Access with a command-line switch?

 

[Tom Wickerath]

See KB article 202039:

How to Programmatically Save a Database or Project as an MDE or ADE File
http://support.microsoft.com/?id=202039


Tom
______________________________________


Is it possible to create an mde file while controlling
Access programatically through automation? I thought I
would be able to do it with the runcommand method, but I
cannot find the appropriate constant. Perhaps it can be
done by calling Access with a command-line switch?

 

[Tony Toews]

Is it possible to create an mde file while controlling
Access programatically through automation? I thought I
would be able to do it with the runcommand method, but I
cannot find the appropriate constant. Perhaps it can be
done by calling Access with a command-line switch?

You can automate MDE creation with the Application.RunCommand method,
using acCmdMakeMDEFile as the argument, either in code or with a
macro.

SysCmd 603, "MDBsamtPfad", "MDEsamtPfad"

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm