3033 do not have the necessary Permissions to use 'MSysTables'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot even find this table, let alone examine its permissions. I have
looked in both front-end and back-end. Using user-level security, users in
Admins group do not get the error - happens when running a query - but
members of a custom security group do. ??
 
MSysTables is a system table.

Go to the View tab in Tools | Options and ensure that the Show System
Objects checkbox is selected.
 
I do have Show System Objects selected, but this table does not appear.
However, I have been able to overcome the error condition by rebuilding the
front-end database from scratch. Of course I had to go through and reapply
all my user-level security settings, but it is not a large .mdb so I was able
to get through it fairly quickly.
BTW, MSysTables does not appear in the new mdb, either, and I do have Show
System Objects checked.
Thanks for your help.
 
Back
Top