I'm trying to link to an Oracle table within Access 2007 via an Oracle ODBC
connection but I'm having no luck. The strange thing is I can go into the
ODBC Data Source Administrator in Control Panels->Administrative Tools
and successfully test the connection. However, within Access 2007 when I
try
to link to a table with that ODBC connection I just get an 'ODBC
connection
failure' message. I'm running Vista SP1 and Office 2007 SP1.
I should also mention that this all works with my XP image and Access 2003
without any hiccups.
Is this some sort of trust center problem? Vista issue? Any suggestions?
-Brian
