Can not execute MSysobjects because of permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim L - 24 Sep 2006 20:10 GMT

I am trying to open and access fill using .Net 2.0 and the OLEdb. The db
opens but when I try to read the msysobjects with a select I get an error
that the table does not have read permissions.

Signature

Jim L. EWeb Tracker, Inc.

Reply to this Message

Douglas J. Steele - 24 Sep 2006 20:52 GMT

Do you have the appropriate permissions to the folder where the MDB file
exists? You need RWXD (Read, Write, eXecute, Delete).

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am trying to open and access fill using .Net 2.0 and the OLEdb. The db
> opens but when I try to read the msysobjects with a select I get an error
> that the table does not have read permissions.

Reply to this Message

Access_Misfit - 15 Mar 2007 16:49 GMT

>I am trying to open and access fill using .Net 2.0 and the OLEdb. The db
>opens but when I try to read the msysobjects with a select I get an error
>that the table does not have read permissions.

This requires a few up-front operations to make this work.
A) First make MSysObjects VISIBLE (Tools|Options|ViewTab| [X] See
SystemObjects)
B) Then make MSysObjects READABLE. (Tools|Security>|User&GrpPermissions|(pick
MSysObj)[X]ReadData)

C) *optional* you can hide MSysObjects by doing the opposite of stepA).

Then your ODBC calls into MSysObjects will return your
tablelists/querylists/etc.

Reply to this Message