I'm getting the following error when I try to save a query. I have security set and I have FULL permission for my login including admin permissions. Can some one help? I'm using ACCESS 2003. Thanks.

You do not have the necessary permissions to use the 'MSysTables' object. Have your system administrator or person who created this object establish appropriate permissions for you.

Recommended Answers

All 2 Replies

Hi,

In User and Group Permission, u have to Set all (Read Design, Modify Design....all) the Permissions for :
"<NewTables/Queries>"

Regards
Veena

I do have Read Data, Update Data, Insert Data, Delete Data, Read Design, Modify Design, and Administer all checked for <New Tables/Queries>. That's why I'm so baffled as to why I can't create a new table or query?????
Any more suggestions???
Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.