Re: JDBC with Access: can't read MSysObjects hidden table

Article View: comp.databases.ms-access

Article #493

Back to comp.databases.ms-access Previous Next

#493

From: Dimitri Furman
Date: Thu, 19 Jul 2001 11:33

15 lines
1374 bytes

On Jul 19 2001, 06:37 am, AB <ab0502@yahoo.com> wrote in 
news:3B56B868.5050906@yahoo.com:

> does someone know how to enable read
> permission on MSysObjects (hidden) table
> on MS Access using the JDBC-ODBC driver ?
> 

Not sure about JDBC part, but in case of regular Jet ODBC driver, to get to 
MSysObjects, you need to specify a workgroup database and the default Admin 
user in the connection properties. The user account you are using must be a 
member of the Users group in order to see MSysObjects.

-- 
(remove a 9 to reply by email)

Technical Details

Message-ID: <Xns90E34CDAAC39Ddfurmancloud99@207.126.101.100>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail

References: <3B56B868.5050906@yahoo.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,855448a1b0305243
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f631b,855448a1b0305243
X-Google-Attributes: gidf631b,public
X-Google-ArrivalTime: 2001-07-19 04:33:15 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: dfurman@cloud99.net (Dimitri Furman)
Newsgroups: comp.databases.ms-access,fr.comp.lang.java
Subject: Re: JDBC with Access: can't read MSysObjects hidden table
Date: Thu, 19 Jul 2001 11:33:14 -0000
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <Xns90E34CDAAC39Ddfurmancloud99@207.126.101.100>
References: <3B56B868.5050906@yahoo.com>
User-Agent: Xnews/4.05.03
X-Complaints-To: newsabuse@supernews.com
Lines: 15

Reply to Parent Message