|
Hi Christine,
In addition to SQL Developer 1.1.2, you need the migration extensions, which are available via check for updates.
The issue with your connection, is explained in the online help available in the new connection dialog. Here are the details:
Access tab
For a connection to a Microsoft Access database, click Browse and find the database (.mdb) file. However, to be able to use the connection, you must first ensure that the system tables in the database file are readable by SQL Developer, as follows:
1. Open the database (.mdb) file in Microsoft Access.
2. Click Tools, then Options, and on the View tab ensure that System Objects are shown.
3. Click Tools, then Security, and, if necessary, modify the user and group permissions as follows: select all tables whose names start with Msys, and give the Admin user at least Read Design and Read Data permission on these tables.
4. Save changes and close the Access database file.
5. Create and test the connection in SQL Developer.
Donal
|
