32bit R within 64bit Knime?

I need to use 64bit Knime for the extra memory, however, I would like to save some of my data streams into a MS Access database.  Problem is, this database is 32bit version, so the database connector doesn't allow a 64 to 32 bit connection.

I had a clever idea to use R to do the dirty work.  However, it seems that Knime will automatically use the 64 bit version of R as well.  Is it possible to have Knime use 32bit R within the 64bit Knime?

No, this is not possible. You cannot mix 32bit and 64bit programs/libraries.

The only thing that might work is if you use the old and deprecated R nodes that communicate to an external R process via files.