|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 9th, 2006, 11:05 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Can't delete relationships
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? 
|
|
#2
November 9th, 2006, 11:17 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't delete relationships
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" wrote in message ... 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?
|
|
#3
November 9th, 2006, 11:30 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't delete relationships
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" wrote: 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" wrote in message ... 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?
|
|
#4
November 10th, 2006, 12:49 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't delete relationships
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" wrote in message ... 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" wrote: 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" wrote in message ... 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?
|
|
#5
November 10th, 2006, 06:03 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't delete relationships
Thanks. That fixed it. Don't know why I didn't think of that sooner. Guess
I'm just new to database design. "Jeff Boyce" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
