[AccessD] Permissions to 'MSysTables' object - SOLVED

Mcgillivray, Don [ITS] donald.a.Mcgillivray at mail.sprint.com
Mon Mar 28 17:19:08 CST 2005


Never mind.  I gave the users "modify" permissions to the queries in
question and that seems to have worked.

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mcgillivray,
Don [ITS]
Sent: Monday, March 28, 2005 11:12 AM
To: AccessD
Subject: [AccessD] Permissions to 'MSysTables' object


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 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list