Ok I managed to solve it myself with the help of Google.
Here is what the problem was: I had 64bit Java and Ignition, but Access is 32bit. I had to uninstall Ignition and Java and reinstall 32 bit versions and I now have a valid connection.
Thanks!
-Shawn