DJK(John) Robinson
djkr at msn.com
Wed Jan 25 12:23:30 CST 2006
You can certainly reach Oracle tables from Access as front end via ODBC. I haven't done it recently - not since 2005 - so I'm rusty on details, but it should NOT be a big deal! (Setting it up initially needs: permissions obviously, DSN, and - uh - something else Oracle-oriented on your PC I think. Sorry, brain is elsewhere!) John -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Tesiny, Ed Sent: 25 January 2006 17:27 To: Discussion of Hardware and Software issues Subject: [dba-Tech] Access/Oracle To access our agency's data we have to use this %$#@& Oracle tool called Discoverer. Could one access Oracle tables using Access as a front end through an ODBC connection. If so, would it be a big deal to set this up. The last time I asked, the IT answer was we can't do that. Never got a why we can't do that??? Anyway, that person is now gone and I'm wondering if I should give it another try. Any thoughts/advice appreciated. Ed Edward P. Tesiny Assistant Director for Evaluation Bureau of Evaluation and Practice Improvement New York State OASAS 1450 Western Ave. Albany, New York 12203-3526 Phone: (518) 485-7189 Fax: (518) 485-5769 Email: EdTesiny at oasas.state.ny.us _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com