error involving 64-bit windows 7, can't figure it out

Hello all,

I've been working on a program for one of my classes, and I keep running into this same error. After doing some research I found that the problem lays in my OS's initial compatibility with Microsoft Access.

Here is the error: java.sql.SQLException:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and the Application

Now, I've already tried a couple different things to try and fix this (I'll list what I've tried below), but to no avail. I am sure that there has to be someone else out there who has experienced a problem like this before but managed to solve it. (I'm running Windows 7 64-bit Professional Edition.)

1) installing the 64-bit drivers for Microsoft Access (this fails and brings up an error saying that I must first uninstall my 32-bit version first, but after I did more research, it turns out that the 64-bit
drivers are already installed on my computer, they are just hidden in the sysWOW64 folder)

2) redirecting the "Target" and "Start in: " folders to "%windir%\syswow64\odbcad32.exe" instead of the original folder, which only held the 32-bit drivers.

Thanks in advance for the help, it's greatly appreciated!

Can you check this thread about the same subject?

Ah yes, well that was the first thing I did (#1). I called it the 64-bit driver, guess that's not the correct name lol. Unfortunately it changed nothing for me : (