469,307 Members | 2,507 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,307 developers. It's quick & easy.

Make ACCDE file

157 100+
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
Dec 20 '09 #1
4 5258
ADezii
8,800 Expert 8TB
@MrDeej
Try:
Expand|Select|Wrap|Line Numbers
  1. Dim app As New Access.Application
  2.  
  3. '****************** Customize to your needs ******************
  4. Const conDB_TO_CONVERT As String = "C:\Test\Test.accdb"
  5. Const conCONVERTED_DB As String = "C:\Test\Test.accde"
  6. '*************************************************************
  7.  
  8. app.AutomationSecurity = msoAutomationSecurityLow
  9.  
  10. app.SysCmd 603, conDB_TO_CONVERT, conCONVERTED_DB
Dec 20 '09 #2
MrDeej
157 100+
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
Dec 20 '09 #3
ADezii
8,800 Expert 8TB
All I can tell you is that it works fine in Access 2003, and I am not running 2007 to test the code. Sorry.
Dec 20 '09 #4
MrDeej
157 100+
Ok. I will try some more and post the solution if I find it in this tread
Dec 21 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by mark | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.