[AccessD] Error Message while Connecting Access to Oracle

I connect an Access front end via ODBC to Oracle painfully and infrequently to validate a few tables.  I can only get connected if the dsn is physically located in the same folder as tnsnames.ora.  And I must recreate it each time.  

I learned this much by dreary trial and error; I wish I knew more!

Thanks,

Liz