Can't delete relationships

[Zoe]

I am an inexperience user of access. I am trying to delete some
relationships, but i get this message: Record(s) cannot be deleted; No delete
permissions on 'MSysObjects'. What do i need to do?

 

[Jeff Boyce]

How are you trying to "delete some relationships"? Why are you "messing"
with MSsysObjects (are you?)?

Have you opened the relationships window, highlighted a relationship,
right-clicked it, and selected "Delete"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Zoe]

I don't know if i have messed with MSysObjects, but i am a little too
inquisitive at times and i could have.

Yes, i am trying to delete relationships in the relationships window by
highlighting them and pressing delete.

 

[Jeff Boyce]

I'm not sure why MSysObjects believe they are involved (well, actually,
Access needs to do things behind the schenes to work with the objects you
see, so it doesn't surprise me that MSysObjects is involved, it's just that
I don't understand why the error message is cropping up).

If this were mine, I probably wouldn't care "why"... I'd probably open a new
empty database and import the tables as a way of getting around Access not
deleteing the relationship.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Zoe]

Thanks. That fixed it. Don't know why I didn't think of that sooner. Guess
I'm just new to database design.