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
With AccessApplication
.AutomationSecurity = 1 'MsoAutomationSecurityLow
.UserControl = True
.SysCmd 603, sourcedb, targetdb 'this makes the ACCDE file
.Quit
End With
Here is the code that creates the 64-bit ACCDE:
Set AccessApplication = New Access.Application
With AccessApplication
.AutomationSecurity = 1 'MsoAutomationSecurityLow
.UserControl = True
.SysCmd 603, sourcedb, targetdb 'this makes the ACCDE file
.Quit
End With
My Computer
At a glance
Win7-64Intel i7-3770S16GBnVidia GT630
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Custom built
- OS
- Win7-64
- CPU
- Intel i7-3770S
- Motherboard
- ASUS P8Z77-M
- Memory
- 16GB
- Graphics Card(s)
- nVidia GT630
- Sound Card
- onboard
- Monitor(s) Displays
- dual
- Screen Resolution
- 1920x1200 (primary) 1050x1680 (secondary)
- Hard Drives
- 128GB SSD (boot)
64GB SSD (Temp/My Documents)
500GB (photos/videos)
1TB (rendered video, backups)
- PSU
- 650W
- Case
- Thermaltake A30
- Cooling
- Thermaltake
- Keyboard
- Logitech Lighted
- Mouse
- Kensington Expert Mouse (trackball)
- Internet Speed
- FIOS 35/35
- Antivirus
- MS Security Essentials
- Browser
- Chrome (beta)