Hale, Jim
Jim.Hale at FleetPride.com
Tue Sep 18 10:20:02 CDT 2007
ODBC connections over long distances has never worked for me- too slow and prone to corruption. Pass through queries, OTOH, have always worked well for me since the heavy lifting is done on the host machine and only the result set is delivered to Access. Jim Hale -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Morrill Sent: Tuesday, September 18, 2007 9:49 AM To: Accessd at databaseadvisors.com Subject: [AccessD] {Accessd] ODBC driver to Oracle to enable Access queries 9-18-07 I have a client who wishes to link up to Oracle databases in several US cities. These hookups would be up to 1000 miles from his office. He wants to use an Access ODBC driver via the Internet to enable Access querying. He has asked me to check this out as to the whys and wherefores. Help!!!!!. Is it possible to do this? Any books/articles on this topic? Thanks in advance, Bill -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.