Permission on msysobjects

[susanjoseph]

Hi
I would like to read the contents of the
msysobject table through VB.The code used is
Set rs = db.Execute("select count(*) from msysobjects where type=1 and name like 'rt*' with owneraccess option")
But an error message saying "No read permission on 'msysobjects' pops up.

Could you help me on this.

Thanks
Susan

 

[Pat Hartman]

Log in to the database with a userID that has admin rights and give yourself read permissions to the MSys tables.

 

[battles]

...give yourself read permissions to the MSys tables.

How do you do that?

And can you do it remotely via VBA code?

(I have to modify 180 Access databases!)