[AccessD] Permissions to 'MSysTables' object

Mcgillivray, Don [ITS] donald.a.Mcgillivray at mail.sprint.com
Mon Mar 28 13:11:31 CST 2005


Hello, All

I have some code that sets the SQL property of a query's QueryDef.  When
I run the code as the system admin, all's well.  If another user -
without admin rights on the db - runs the code, they get the error:

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

I've searched the db window (yes, I made system objects visible) but I
cannot see any such object in the db.  I've searched the front end, the
back end, and the related db workgroup file.  I see MSysAccessObjects,
MSysAccessXML, MSysACEs, MSysObjects, MSysQueries, and
MSysRelationships, but no MSysTables.

I'm using Access XP on Windows 2000.

Maybe somebody can point me in the right direction here.

Thanks!

Don 




More information about the AccessD mailing list