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
|
|||
|
|||
MSysRelationships
how can i get insert permission on the MSysRelationships table ?
tia |
#2
|
|||
|
|||
MSysRelationships
On Wed, 19 May 2010 00:32:14 +0200, "Loterken" wrote:
how can i get insert permission on the MSysRelationships table ? tia You can't, you needn't, and you shouldn't! That's sort of like rebuilding your car's transmission... with the engine running in traffic g. I'd use VBA with the CreateRelation method to accomplish what you're trying to do. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
MSysRelationships
I'd use VBA with the CreateRelation method to accomplish what you're
trying to do Thanks John, i was afraid i had to do that but if there is no other way, i'll do it |
#4
|
|||
|
|||
MSysRelationships
If you want to use SQL instead of DAO, what you
are looking for is a statement using ALTER TABLE ... CONSTRAINT ...FOREIGN KEY...REFERENCES Depending on what you are doing, you may have to first use CREATE INDEX (david) "Loterken" wrote in message ... how can i get insert permission on the MSysRelationships table ? tia |
#5
|
|||
|
|||
MSysRelationships
Thanks david
but that is what i was trying to avoid i was looking for an easy way out...just inserting records in MSysRelationships but if it cannot be done...then it cannot be done |
#6
|
|||
|
|||
MSysRelationships
It's not that it can't be done, it's just that that table
is only the report table for the relationship view window. The actual relationships are foreign key relationships on the other tables. (david) "Loterken" wrote in message ... Thanks david but that is what i was trying to avoid i was looking for an easy way out...just inserting records in MSysRelationships but if it cannot be done...then it cannot be done |
Thread Tools | |
Display Modes | |
|
|