By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Make ACCDE file

100+
P: 157
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
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,638
@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

100+
P: 157
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
Expert 5K+
P: 8,638
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

100+
P: 157
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.