The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

Look for the above folder in the WOW64 directory to configure your connection to the ACE OLE DB driver for Access 2007 and you should also look for the x86 SQL Server directory the only requirement your application must build x86. That includes SSIS packages because when you are using x86 with x64 you build lower.