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
Don't know if this page will help, but just in case: http://download.oracle.com/docs/cd/B25329_01/doc/appdev.102/e10045/toc.htm -- Thanks, Bob Larson Access MVP "Brian Douglas" wrote in message news:%23J%23XGqj1IHA.2064@TK2MSFTNGP05.phx.gbl... > 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 > >
