Access MSysRelationships Administer Permission

I am showing that the MSysRelationships table is owned by 'engine', and I am showing current user is 'Admin'

Everytime I try to change perms for MSysRelationships, I get the 'you don't have permissions error'

What am I doing wrong?

Microsoft Access

Last Comment

Scott McDaniel (EE MVE )

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

peter57r

2/26/2009

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

peter57r

2/26/2009

System tables are excluded from Access's security - they cannot be changed by anyone.

Scott McDaniel (EE MVE )

2/26/2009

What are you trying to do with the relationships?

CaseyDeshotels

2/26/2009

ASKER

I am doing a conversion to another db.

The instructions were to enable visibility, then add administer or read priveliges to the MSys tables

If I export the tables to a fresh access db, I have no problems doing the procedure to the MSysRelationships, etc tables.

Your help has saved me hundreds of hours of internet surfing.

fblack61

peter57r

2/26/2009

It doesn't make any difference what you do to the permissions in the security dialog.
You will not be able to change the tables or data no matter what permissions you grant, and you can already read the data without the permissions being set.

Scott McDaniel (EE MVE )

2/27/2009

<If I export the tables to a fresh access db, I have no problems doing the procedure to the MSysRelationships, etc tables.>

As peter said, you cannot alter permissions on those tables ... I'm not sure where you got those "instructions", but they are wrong.

Certified Expert Program

Credly Partnership

Udemy Partnership