This content has been marked as final. Show 22 replies
You have to grant access to the system objects which is off by default. To do this you would have to open the mdb with Access and goto the Tools->Options and make sure System Objects is checked.
Then you'll have to grant access to those system objects. This is done my going to Tools->Security.
This is about the extent of what I know about when the guys get back next week , they should be able to answer more if you are still stuck.
You have to grant access to the system objects whichWhy is that?
is off by default. To do this you would have to open
the mdb with Access and goto the Tools->Options and
make sure System Objects is checked.
Then you'll have to grant access to those system
objects. This is done my going to Tools->Security.
Which information is needed by SQL Developer that is not provided by the JDBC API?
I can get a list of tables and views through JDBC without the need to give read access to those tables (it does not even require Access to be installed, the necessary ODBC driver is part of Windows)
I still can't get this working. I've got a access database called db1. There are 2 tables and a linked table it Microsoft Access 2000 file format.
1) tools options and under the view tab I've checked the box next to system objects.
2) Tools\Security\User and Group Permissions
3) Checked the box next Groups
4) Selected Users from the User/Group Name box
5) Select all the MSys objects from the object name box where object type box is set to table
6) checked the read data box which automatically also checks the read design box
7) click apply and then ok
8) Closed Access Database
9) Open SQL Developer select create new connection
10) Name connection browsed to mdb file
11) click test button
No Read Access to System Tables. Modify Access db before retrying
If I click ok, in the bottom left hand corner of the New/Select Database connection it says success. If I then click connect it comes up with the same error message, but it closes the new connection box and I can see the connection in the connection tree. When I click the + next to the connect and then to the tables it says ".....no read permission on 'MsysObjects'.
am I doing something wrong?
I've just checked and if I do a SQL Statement it works, even though the above error messages etc appear and I can't actually see the table queries etc in the connection tree.
Message was edited by: rmcrae
Everthing u are doing is right. The problem as dermot puts it is that you need to be able to read those tables to use the explorer. Access is not great at sharing its metadata with the world and so it requires SU proviliges on the db to do that.
You will definitely get the connection, its just jdbc/odbc, but you need the extra permissions to get the navigator to show you the objects in the dtabase.
After checking "system objects" in the View section of Tools > Options, you have to make sure that Admin can read those new objects.
In Tools > Security > User and Group Permissions, check each table that is prepended with "MSys..." to see if the Permissions boxes are checked. If they are not, check them. Once Admin has full privileges on these tables, SQLDeveloper should have no problems.
I did exacly the same and I am encountering the same difficulty browsing MS Access DB. All the containers are empty.
Does anyone have any clue to this problme?
OSD site does not provide any walk throughs or tutorials on how to go about accessing MS Access DB. I wonder if this feature even works as claimed.