Make ACCDE file

[MrDeej]

Anybody now if i can do this programtically?

My challenge is that i have a maybe 10 distributions a week with updates and changes which i now have found the accde format to be of good use. I also want to force our developers to change the title, write version history and so before we make the accde file and all that i can manage if we can get VBA to make the ACCDE file instead of pushing the button in Access

[ADezii]

Convert accdb to accde via VBA

Anybody now if i can do this programtically?

My challenge is that i have a maybe 10 distributions a week with updates and changes which i now have found the accde format to be of good use. I also want to force our developers to change the title, write version history and so before we make the accde file and all that i can manage if we can get VBA to make the ACCDE file instead of pushing the button in Access

Try:

Dim app As New Access.Application

'****************** Customize to your needs ******************
Const conDB_TO_CONVERT As String = "C:\Test\Test.accdb"
Const conCONVERTED_DB As String = "C:\Test\Test.accde"
'*************************************************************

app.AutomationSecurity = msoAutomationSecurityLow

app.SysCmd 603, conDB_TO_CONVERT, conCONVERTED_DB

[MrDeej]

If i translate the error message from norwegian to english it says something like

"You have performed a illegale function call"


edit: i had a typo in the code.

Now it runs trough the code, but without results.. It does create a new .accde file

[ADezii]

All I can tell you is that it works fine in Access 2003, and I am not running 2007 to test the code. Sorry.

[MrDeej]

Ok. I will try some more and post the solution if I find it in this tread