Is there a way to compile a 32-bit ACCDE file from an Access 2010-64 ACCDB file? I have a client who has both 32 & 64 bit systems and I have an automated way to create a 64-bit ACCDE but a 64-bit ACCDE will not run on their 32-bit systems. So I need to add code (if possible) to create a 32-bit ACCDE from a 64-bit system.
Here is the code that creates the 64-bit ACCDE:
Set AccessApplication = New Access.Application
.AutomationSecurity = 1 'MsoAutomationSecurityLow
.UserControl = True
.SysCmd 603, sourcedb, targetdb 'this makes the ACCDE file