oracle - Connect to a MS Access database with SQL Developer

Question

I have a Microsoft Access database (.accdb extension) that I would like to query with SQL developer version 19.4. Is this possible? and how do I achieve this? I am not planning on migrating the database, I would just like to be able to query it with SQL (as I am not familiar with Access).

When I create a new connection I don't have the possibility to select Access in a tab with this version of SQL developer. When I use an older version it is there, but it doesn't support the extension of my Access database.

I found this as well: Connecting MS Access to Oracle SQLDeveloper But the suggestions done there are not suitable for me unfortunately.

标签： oraclems-accessoracle-sqldeveloper

Answer 1

不，这是不可能的。

我们曾经通过 odbc-jdbc 桥接器提供此功能，但我相信 Java 7 不再提供此功能。

我们尚未构建对 Access JDBC 驱动程序的本机支持。

如果您能找到 SQL Developer 版本 3 的副本，您就可以随心所欲，开箱即用。