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

Article View: comp.databases.ms-access

Article #491

Back to comp.databases.ms-access Previous Next

#491

From: Bob Hassel
Date: Fri, 20 Jul 2001 16:51

22 lines
1959 bytes

I have some users seeing that message as well.  They are theoretically
loggin in with they're own login and password that's in the mdw file. 
Mostly the users that experience that have read access (not write) to
both the database and directory.

What's happening here?

Bob

dfurman@cloud99.net (Dimitri Furman) wrote in message news:<Xns90E34CDAAC39Ddfurmancloud99@207.126.101.100>...
> 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.

Technical Details

Message-ID: <a15c2dd9.0107200851.6cc8960b@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!postnews1.google.com!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f631b,855448a1b0305243
X-Google-Attributes: gidf631b,public
X-Google-Thread: ff0ac,855448a1b0305243
X-Google-Attributes: gidff0ac,public
X-Google-ArrivalTime: 2001-07-20 09:51:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!postnews1.google.com!not-for-mail
From: bob.hassel@directlink.net (Bob Hassel)
Newsgroups: comp.databases.ms-access,fr.comp.lang.java
Subject: Re: JDBC with Access: can't read MSysObjects hidden table
Date: 20 Jul 2001 09:51:02 -0700
Organization: http://groups.google.com/
Lines: 22
Message-ID: <a15c2dd9.0107200851.6cc8960b@posting.google.com>
References: <3B56B868.5050906@yahoo.com> <Xns90E34CDAAC39Ddfurmancloud99@207.126.101.100>
NNTP-Posting-Host: 198.94.28.74
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 995647862 12674 127.0.0.1 (20 Jul 2001 16:51:02 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 20 Jul 2001 16:51:02 GMT

Reply to Parent Message