If you are running an Oracle database on a UNIX or Linux platform and want to read/write data in a remote Microsoft Access database you can use Oracle's heterogeneous services (hsODBC) and the ODBC-ODBC Bridge.
Oracle's Heterogeneous Services allows you to use Oracle SQL to transparently access data stored in non-Oracle systems as if the data was stored within an Oracle server.
Oracle 9i and Oracle 8i users can find detailed instructions on how to set this up in the following article Accessing ODBC and JDBC Data Sources from Oracle Heterogeneous Services (hsODBC).
Oracle 12c (and later) users can refer to Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC). Although this document describes how to connect Oracle to a remote SQL Server database, the process is the same for Microsoft Access. In the Install, Configure and Test the ODBC Driver section, configure an ODBC-ODBC Bridge client data source that points to a system ODBC data source for the target Access database.
You can also use the ODBC-ODBC Bridge to connect to any other remote Windows database from Oracle.
You can find other ODBC Drivers that you can use with Oracle's Heterogeneous Services here.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
