You can indeed install the 64 bit edition of the Access Database Engine 2010 when the 32 bit edition is installed. You need to add a /passive switch and install it from the command line. See the Microsoft Access Database Engine 2010 Redistributable blog posting for more details.
Now who was the original discoverer of this quirk I have no idea. I couldn’t find any mention of this on the MS website but …
Thanks to Sameer Panse in the Should Access Database Engine match OS install or Office install? posting for finding this option.
Turns out the problem was “an invalid character in the file name. “
Thanks to Septimus for raising the issue OutputTo DPF Error and figuring out the problem.
If you are getting the above error message check the length of the path of the Access database. A client had this problem where the path and Access database file name was “only” 181 characters. Testing shows that the length of the path and the Access database file must be under about 128 characters. Bizarre.