Connecting to Microsofot Access 2010 database with SQL Developer

Question

I'm trying to connect to an Access table database with Oracle SQL Developer.  In the past I've had to modify the database to enable SQL Developer to read the system tables in order for it to work properly.

If I don't do that I get the message "No Read Access to System Tables.  Modify Access db before retrying".  It can still connect, but none of the tables or other objects show up in the connection browser.  In Access 2003 and earlier versions, this could be accomplished by setting the privileges in the "view / security" dialog.  However, that options doesn't exist in 2007 or 2010.  Am I missing something?  Is there another way to accomplish the same thing?

Thanks in advance.

Answer 1

SummerBob wrote in

news:*** Email address is removed for privacy ***

m:

If I don't do that I get the message "No Read Access to System

Tables.¶ÿ Modify Access db before retrying".¶ÿ It can still

connect, but none of the tables or other objects show up in the

connection browser.¶ÿ In Access 2003 and earlier versions, this

could be accomplished by setting the privileges in the "view /

security" dialog.¶ÿ However, that options doesn't exist in 2007 or

2010.¶ÿ Am I missing something?¶ÿ Is there another way to

accomplish the same thing?

Is it an MDB or an ACCDB? If the former, it's the same as it always

was. If the latter, there shouldn't be any issues in the first

place. But you do have to use the correct connect string, i.e., you

need the ACE and not Jet 4 in order to connect to an ACCDB.

---

David W. Fenton                  http://www.dfenton.com/ contact via website only     http://www.dfenton.com/DFA/