Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I get an Access tab for a new Connection?

mdwyerMar 10 2015 — edited Mar 13 2015

SQL Developer 2.1.1.64

Go to View / Connections

Click the green + (plus) symbol

A New / Select Database Connection dialog appears

On the right side, below the connection name, username, and password fields is a tabbed area for Role, Connection Type, and connection details. The tab says Oracle.

The documentation for migrating the MS Access Northwind database says to create a connection to the Access database using the Access tab on this dialog.

Where is it/how do I get it?

The same documentation also suggests that after installing and launching SQL Developer, to go to Help / About / Extensions and review the list of installed extensions. While looking for Oracle Migration Workbench, I found Oracle SQL Developer Migrations, and several other hyphenated entries, including - Microsoft Access. The identifier for this is oracle.sqldeveloper.migration.msaccess, v.11.1.1.64.45, status=Loaded. This seems to suggest that the Access module was installed, but that's only a guess.

As the OTN forums seem about as reliable as the documentation, if someone has an answer to post here, could you also send an email XXXXXX com?

Thanks!

Message was edited by: PhHein Email address removed

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 10 2015
Added on Mar 10 2015
16 comments
3,120 views