Save a Database as an MDE File

[Roberto]

Friends:

"How to Programmatically Save a Database or Project as an MDE or ADE File"
without accmdMakemdefile????

Microsoft have this solutions (with accmdMakemdefile):

http://support.microsoft.com/defaul...port/kb/articles/Q202/0/39.ASP&NoWebContent=1

Function GenerateMDEFile(MyPath As String)

Dim NAcc As Access.Application

Set NAcc = CreateObject("Access.Application")

'The following lines simulate accepting the default
'name, clicking Make MDE, and clicking Save
SendKeys MyPath & "{Enter}{Enter}"
SendKeys "{Enter}"

NAcc.DoCmd.RunCommand acCmdMakeMDEFile

Set NAcc = Nothing

End Function


the code uses SendKeys, but is not a robust method.

If you have any answer for me, I'm going to appreciate it

Thanks , best regards

Mari Hickmann

 

[Mari]

Joan:

thak´s a lot for your answer.

I know the undocumented method using SysCmd from Dan Haught, but this method
don´t apply for Access 2k or early

If you have any answer for me, I'm going to appreciate it

Thanks , best regards

Mari Hickmann/Roberto

 

[Joan Wild]

"How to Programmatically Save a Database or Project as an MDE or ADE
File" without accmdMakemdefile????

I've never used this, but you could try (on a copy)
SysCmd 603, PathToSourceMDB, PathToDestinationMDE