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

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. ??
 
D

Douglas J. Steele

MSysTables is a system table.

Go to the View tab in Tools | Options and ensure that the Show System
Objects checkbox is selected.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top