vba to create a .accde file with 64-bit Access 2013
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
Jim.
With accessApplication
.UserControl = True
.AutomationSecurity = 1
.SysCmd 603, SourceDB, TargetDB
End With
However, opening the accde file shows a white background on some buttons. I will upload a pic if I have that option.
Thank you capricorn1 and Jim Dettman.
Personally I would not use that call. There's too many things needed to make a xDE successfully that cannot be automated.
I know a number of people have tried, but all have given up in the end. It's just one of those things that probably should remain a manual operation.
Even that aside, the thing with the 603 call is that it may only be one of many steps of the process internally in Access that gets performed when you use "Save as". 603 may be doing nothing more than stripping the source code out and not updating resources, checking that the app is compiled, etc.
In fact your result proves that given that you get a different result.
Jim.
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Join our community and discover your potential
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.