MAKE ACCDE with VBA

  • Thread starter Thread starter uGek010
  • Start date Start date
U

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make ACCDE Help 4
Locked VBA causes Access to crash with ACCDE files 1
Ac 2007 vs .NET 1
Tips for ACCDE and ACCDR 6
ACCDE file not working properly 2
Access 2007 and ACCDE 5
Deployment Help!? 5
Dates don’t work within WHERE clauses 2

Back
Top