MAKE ACCDE with VBA

[uGek010]

Does anyone know what the VBA command is for making a 2007 database (Accdb)
to a Accde?

I just upgraded to 2007 but can't find any references to replace this line
of code

MyDB.DoCmd.RunCommand acCmdMakeMDEFile

In advance, your assistance is greatly appreciated.

[uGek010]

Found the answer
Public Function MakeACCDESysCmd(InPath As String, OutPath As String)

Dim app As New Access.Application

app.AutomationSecurity = msoAutomationSecurityLow

app.SysCmd 603, InPath, OutPath

End Function

[Keef Faulkner]

This no longer seems to work in office 2010

> On Monday, January 14, 2008 4:20 PM uGek01 wrote:

> Does anyone know what the VBA command is for making a 2007 database (Accdb)
> to a Accde?
>
> I just upgraded to 2007 but can't find any references to replace this line
> of code
>
> MyDB.DoCmd.RunCommand acCmdMakeMDEFile
>
> In advance, your assistance is greatly appreciated.

>> On Monday, January 14, 2008 6:52 PM uGek01 wrote:

>> Found the answer
>> Public Function MakeACCDESysCmd(InPath As String, OutPath As String)
>>
>> Dim app As New Access.Application
>>
>> app.AutomationSecurity = msoAutomationSecurityLow
>>
>> app.SysCmd 603, InPath, OutPath
>>
>> End Function
>>
>> "uGek010" wrote:

>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>> Using ASP.NET Session with Silverlight and WCF Services
>> http://www.eggheadcafe.com/tutorials/aspnet/c72cc77a-bf84-4180-a35b-46b8726ab782/using-aspnet-session-with-silverlight-and-wcf-services.aspx

[Keef Faulkner]

Please ignore my last post - it does still work in Access 2010

Submitted via EggHeadCafe - Software Developer Portal of Choice

JustCode Visual Studio Development Add-In by Telerik
http://www.eggheadcafe.com/tutorials/aspnet/d174b33a-d86e-48e7-b381-fcd1938b6775/justcode-visual-studio-development-addin-by-telerik.aspx