Create an accde file using VBA

[Mjoyce1962]

Is it possible to create an accde file from an accdb file using VBA? Either the currently open database or one that is external to the currently open database would work for the purpose I have in mind.

You guys are geniuses so I know that if it can be done one of you will have the answer so thanks in advance!

m

[NeoPa]

Have you considered Application Automation?

[twinnyfo]

This will work for converting a different, non-open DB:

Public Sub CreateACCDE()
    Dim strDBFile As String
    Dim strDEFile As String
    Dim objACC As Access.Application
 
    strDBFile = "C:\DBFile.accdb"
    strDEFile = "C:\DBFile.accde"
 
    Set objACC = New Access.Application
 
    objACC.SysCmd 603, strDBFile , strDEFile 
    objACC.Quit acQuitSaveNone
 
    Set objACC = Nothing
End Sub

I personally prefer to do it manually, so I can see if there were any errors during the compile.

Hope this hepps!

[NeoPa]

Am I missing something? The code simply does the conversion. The compiling step isn't included.

Doesn't that mean the user would still see the compiler errors directly? Also that the requirement would be for a non-open and compiled database file?

PS. Well done for providing the code. I hadn't realised that step was an undocumented one when I suggested they look up Application Automation.