JDBC with Access: can't read MSysObjects hidden table

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by AB Thu, 19 Jul 2001 10:37

#492

Author: AB
Date: Thu, 19 Jul 2001 10:37

14 lines
1624 bytes

Hello

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

I get the following error (french version)

ErrorCode: -1907
SQLState: 42000
Message: [Microsoft][Pilote ODBC Microsoft Access] Impossible de lire 
   les enregistrements; pas d'autorisation de lecture sur 'MSysObjects'.

Thanx everybody

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

#493

Author: 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads