Wednesday, September 16, 2009

No Read Access to System Tables. Modify Access db before retrying

You may get this message, if you use Oracle SQL Developer to migrate Access data.
To fix this:

Open Access database, go to Tools->Security->User Groups & Permissions

Select each system tables (They all start with MSys), Check all the Check boxes under Permissions.

If the system tables are not visible, go to Tools-> Options -> View tab, and check System Tables

Save.

Now retry from SQL Developer.

1 comment: