472,800 Members | 1,627 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,800 software developers and data experts.

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 5646
8,834 Expert 8TB
Expand|Select|Wrap|Line Numbers
  1. Dim app As New Access.Application
  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. '*************************************************************
  8. app.AutomationSecurity = msoAutomationSecurityLow
  10. app.SysCmd 603, conDB_TO_CONVERT, conCONVERTED_DB
Dec 20 '09 #2
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
8,834 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
157 100+
Ok. I will try some more and post the solution if I find it in this tread
Dec 21 '09 #5

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

Similar topics

by: kannanudt | last post by:
Sir, I had done one application in ms-access2007 using VBA code... now i am converting the database to exe format. At the time one error message raises,,, i.e, "Microsoft...
by: patjones | last post by:
Hi everyone: I have a form in my database called "frmChecks". In the properties for this form, I set On Load to , which points to some code in VB that maximizes the form window and sets a...
by: bigshotj | last post by:
Hey Guys, I have made a small application that has a main form and a sub form. The main form contains fields like Bill No., Name of Customer, Month. and The subform contains several fields like...
by: RobH | last post by:
I am trying to generate a complied version of my Application by clicking on the "Make ACCDE" in Access 2007. It asks me where and with what file name to save the ACCDE however it quickly returns with...
by: Lindsay Browning | last post by:
Hello, I found a previous posting by someone on the 10th Sept (http://www.thescripts.com/forum/thread705528.html) who seemed to have the same problem as me, but it was never resolved. I have...
by: mark | last post by:
Hi, I've converted my Access 2007 database to an accde format as I don't want users to be able to modify it. The only problem is that all the code has stopped working. I have split the database...
by: tuxalot | last post by:
I see that if I convert my FE to an ACCDE that I cannot utilize my linked reports (DoCmd.Transfer not allowed). Is there a way to work with linked reports without transferring them? The reports use...
by: postman | last post by:
I have an application that minimizes the Access application window and displays a pop-up modal form. The Application window is minimized with this command in the form's Load event. ...
by: junaidfaiz | last post by:
resently iv created a software which is working fine in open format and i just have madte it converted to .ACCDE file but have lost all the links attached to it's buttons. It is in the trusted folder...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.