MSysRelationships
in [General]
|
Prev: Access & XML
Next: Re Passport No
From: Loterken on 18 May 2010 18:32 how can i get insert permission on the MSysRelationships table ? tia
From: John W. Vinson on 18 May 2010 18:43 On Wed, 19 May 2010 00:32:14 +0200, "Loterken" <loterken(a)pandora.be> 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]
From: Loterken on 18 May 2010 19:38 > 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
From: david on 19 May 2010 03:09 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" <loterken(a)pandora.be> wrote in message news:Omea4nt9KHA.1892(a)TK2MSFTNGP05.phx.gbl... > how can i get insert permission on the MSysRelationships table ? > tia > >
From: Loterken on 19 May 2010 19:25
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 |