I successfully use the following code for 32-bit Access:
Public Function ConvertToAccde(SourceDB As String, TargetDB As String) As Boolean
Dim accessApplication As Access.Application
ConvertToAccde = False
Set accessApplication = New Access.Application
With accessApplication
.SysCmd 603, SourceDB, TargetDB
End With
ConvertToAccde = True
Set accessApplication = Nothing
Exit Function
However, this code does not work for 64-bit Access 2013. It hangs on the .SysCmd line and never exits.
Suggestions please.
http://answers.microsoft.com/en-us/office/forum/office_2010-access/how-to-make-32-bit-accde-from-64-bit-access-2010/5845b6c7-f3ec-434d-b72d-3eeb7b8d5029?auth=1