Can't delete relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
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
 
Thanks. That fixed it. Don't know why I didn't think of that sooner. Guess
I'm just new to database design.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access '07 Beta 2, "Record(s) cannot be deleted, no delete permiss 4
Where do I set up delete permission on 'MSysObjcts' in Access? 1
Relationships 9
can't change the data type or field size 3
Cannot delete relationships 1
issues on table with relationship to self 4
Can't change data type 3
Removing a field 2

Back
Top