Method to edit system tables?

[Kraeg]

Is there a way to edit Access system tables?

I've set the Owner of MSysRelationships to Admin (it's normally Engine) and all the permissions to allow, but I still can't edit it.

 

[danvlas]

I believe the system tables cannot be edited manually. You have to change the relationships through the Relationships Window or change the Relations collection through code...

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Kraeg]

I've been writing code to change the relationships (basically to copy the relationship details to variables, remove the relationships, then re-establish them using the variables).
I thought that it'd be easier to copy the MSysRelationships table, clear it, then copy the data from the copy of it back into it..... if I could somehow obtain the permissions to edit it.
So I'll guess I'll continue with the coding.

Thanks.