Rocky Smolin
rockysmolin at bchacc.com
Thu Apr 23 15:56:32 CDT 2009
Thanks Liz. I'm going to recommend that they export from my app to a csv file and import into their Oracle app that way. Much easier. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of lizd1 at charter.net Sent: Thursday, April 23, 2009 1:47 PM To: accessd at databaseadvisors.com Cc: accessd-request at databaseadvisors.com Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com