ORACLE: Microsoft Access x64 connect to x86 oracle data source (workaround)

ORACLE: Microsoft Access x64 connect to x86 oracle data source (workaround)

Microsoft Access, Oracle

1. Install oracle drivers

2. Fill tnsnames.ora oracle file with connection to your server

Location i.e. : 

\oracle\product\10.2.0\client_1\network\admin

C:\app\oracle\product\11.2.0\client_1\Network\Admin

3. Add odbc connection 

C:\Windows\syswow64\odbcad32.exe

User: Oracle user name

Server: Server name from TNS names

4. Create symbolic link, junction to C:\Program Files (x86)

cmd

mklink /J "C:\Program Files (x86)\" "Program_Files_86"

5. Create shortcut "Micorsoft Access (x86) to Microsoft Access application with path below:

Location i.e. : 

 C:\Program_Files_86\Microsoft Office\OFFICE11\MSACCESS.exe

 C:\Program_Files_86\Microsoft Office\OFFICE12\MSACCESS.exe

6. Start Microsoft Access from shortcut and run odbc connection